View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 05:52 AM
David Portas
 
Posts: n/a
Default Re: changing the default value for a column

It's a good idea to give constraints meaningful names when you create
them, otherwise the server assigns them an obscure unique identifier
name. Use a consistent naming convention and then you'll know the
constraint names for tables and columns.

You can find the name of an existing default using the Object Browser
in Query Analyzer or in the output of sp_help 'table_name'
--
David Portas
SQL Server MVP
--

Reply With Quote