-- DROP THE FOREIGN KEYS
SELECT 'ALTER TABLE ' + OBJECT_NAME(f.parent_object_id)+
' DROP CONSTRAINT ' + f.name
FROM .sys.foreign_keys AS f
INNER JOIN .sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id
--ADD HERE THE DROP TABLE STATEMENTS OF THE REFERENCES TABLES
-- AND THE CREATE TABLE STATEMENTS
-- ADD THE FOREIGN KEYS AGAIN
SELECT 'ALTER TABLE ' + OBJECT_NAME(f.parent_object_id)+
' ADD CONSTRAINT ' + f.name + ' FOREIGN KEY'+'('+COL_NAME(fc.parent_object_id,fc.parent_column_id)+')'+'REFERENCES ['+OBJECT_NAME (f.referenced_object_id)+']('+COL_NAME(fc.referenced_object_id,fc.referenced_column_id)+')' as Scripts
FROM .sys.foreign_keys AS f
INNER JOIN .sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id
Posts
No comments:
Post a Comment
- the first minus - Comments have to be moderated because of the spammers
- the second minus - I am very lazy at moderating comments ... hardly find time ...
- the third minus - Short links are no good for security ...
- The REAL PLUS : Any critic and positive feedback is better than none, so your comments will be published sooner or later !!!!