Getting Information about Defaults

Default definitions are stored in syscomments.

  • After a default is bound to a column, its object ID is stored in syscolumns. After a default is bound to a user-defined datatype, its object ID is stored in systypes.

  • To rename a default, use sp_rename.

  • For a report on the text of a default, use sp_helptext.