Default Constraints

• Derek Allan Thomson

  SSC Enthusiast

  Points: 145

  More actions

  November 8, 2007 at 6:02 am

  #179254

  I am new to SQL Server programming. I want to list all the details about a default contraint. How do I do this?

  Thanks in advance.:cool:

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  November 8, 2007 at 7:10 am

  #749454

  This should do the job:

  SELECT OBJECT_NAME(d.parent_object_id) AS tablename,

  d.name AS defaultname,

  c.name AS columnname,

  definition

  FROM sys.default_constraints d

  JOIN sys.columns c

  ON d.parent_column_id = c.column_id

  AND d.parent_object_id = c.object_id

  ORDER BY TableName

  [font="Verdana"]Markus Bohse[/font]