Home Forums SQL Server 2005 T-SQL (SS2K5) Dropping DF_ constraints RE: Dropping DF_ constraints
Randy Knight
SSC-Addicted
Points: 468
More actions
November 13, 2012 at 10:16 pm
#1558728
This should get you started. If you want to know the column to script it out you can use the parent_column_id and join to sys.columns.
SELECT OBJECT_NAME(parent_object_id) AS TableName, name AS DefaultName,*
FROM sys.default_constraints