Geeks With Blogs
Title Of Blog January 2013 Entries
Determine all foreign keys in a database
Quick script to determine all foreign keys in your SQL Server database:SELECT AS ForeignKey, OBJECT_NAME(f.parent_object... 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_obje... 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 ......

Posted On Wednesday, January 9, 2013 9:05 AM

Copyright © Jake Rutherford | Powered by: