Sunday, February 27, 2011

Script to Drop the Constraints

SELECT
'ALTER TABLE [' + OBJECT_NAME(f.parent_object_id) +
'] DROP CONSTRAINT [' + F.name + ']' + CHAR(10) +
'GO ' + CHAR(10)
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id