Geeks With Blogs
Title Of Blog
Quick script to determine all foreign keys in your SQL Server database:

SELECT 
    f.name AS ForeignKey,
    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
Posted on Wednesday, January 9, 2013 9:05 AM SQL | Back to top


Comments on this post: Determine all foreign keys in a database

# re: Determine all foreign keys in a database
Requesting Gravatar...
Great reference! Thanks!
Left by Ben Barreth on Jan 09, 2013 1:17 PM

# re: Determine all foreign keys in a database
Requesting Gravatar...
Thank you. This is the cleanest implementation I have seen of this handy query
Left by Nick on Jan 15, 2013 11:12 AM

Your comment:
 (will show your gravatar)


Copyright © Jake Rutherford | Powered by: GeeksWithBlogs.net