Column Properties Window Bug in Management Studio?

This issue deals with where to see the default value for a column in Sql Server 2005 Management Studio.

I have a default value of (1) in a column of type bit:

If you right click on the column in Management Studio object explorer and choose properties, the default value does not appear under "Default Binding" or "Default Schema" in the Column Properties window.

If you select the table and then choose View -> Summary, double click on the Columns folder, then right click -> properties on the column, again the default value does not appear under "Default Binding" or "Default Schema" in the Column Properties window.

If you right click on the table or column and choose "Modify", then select the column, the default value appears in "Default Value or Binding".

If you script the table out (right click -> Script Table as -> Create to), the default value for that column appears in the script.

I'm wondering if this is by design or a bug? Obviously right click-> properties is not a reliable way to view the properties on a column.

Hello Eric,

This issue seems to be a bug in Column Properties page. Could you please report this issue through Connect web site

https://connect.microsoft.com/SQLServer/Feedback

Click on Submit Feedback

Thanks

Sethu Srinivasan

SQL Server Manageability Dev Team