Gourab Mitra gourab5139014
gourab5139014
/ showRelationships.sql
Last active
March 26, 2024 14:59
SQL Server Script to show all FK relationships in the current database
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| fk.name 'FK Name', | |
| tp.name 'Parent table', | |
| cp.name, cp.column_id, | |
| tr.name 'Referenced table', | |
| cr.name, cr.column_id | |
| FROM | |
| sys.foreign_keys fk | |
| INNER JOIN | |
| sys.tables tp ON fk.parent_object_id = tp.object_id |
NewerOlder