SOURCE:http://blog.sqlauthority.com/2009/07/23/sql-server-puzzle-write-script-to-generate-primary-key-and-foreign-key/
-- ADD FOREIGN KEY REFERENCES
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 !!!!