Thursday, 20 April 2017

Foreign Key Drop Statement SQL Server (Automated Script Generation of Foreign Key Constraint)

SELECT 'alter table '+OBJECT_NAME(f.parent_object_id) +' drop constraint '+ f.name AS Fk_Drop_Statement, 
   OBJECT_NAME(f.parent_object_id) AS TableName, 
   COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName, 
   OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName, 
   COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName 
FROM sys.foreign_keys AS f 
INNER JOIN sys.foreign_key_columns AS fc 
   ON f.OBJECT_ID = fc.constraint_object_id
ind of thinking we used when we created them - Albert Einstein"

No comments:

Post a Comment