Object Explorer: Scripting Default Names: How?

microsoft.public.sqlserver.tools

29 Mar 2006 7:07 PM

Dr. Network

In SQL 2000 Query Analyzer, when I generate a script of a table it generates
the default name in addition to the default value for a column when I
generate the table. In SQL 2005 Object Explorer, the default value for the
column is scripted but the default name is not in the script. How do I
configure Object Explorer to script the default name in addition to the
default value when I generate a script for a table?

Thanks.