/SQL/Sql server find all foreign keys that reference a column

Sql server find all foreign keys that reference a column

Tsql find foreign key references

EXEC sp_fkeys 'TableName'

Source: stackoverflow.com

Sql server find all foreign keys that reference a column

SELECT 
   OBJECT_NAME(f.parent_object_id) TableName,
   COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM 
   sys.foreign_keys AS f
INNER JOIN 
   sys.foreign_key_columns AS fc 
      ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN 
   sys.tables t 
      ON t.OBJECT_ID = fc.referenced_object_id
WHERE 
   OBJECT_NAME (f.referenced_object_id) = 'YourTableName'

Source: stackoverflow.com

Similar codes

0 vote192 views1 answer
Prodection ready postgres database step by step
SQL
0 vote187 views1 answer
Psql get table data types
SQL
6 votes190 views1 answer
Sqlite foreign key
SQL
28 votes188 views6 answers
Mysql change user password
SQL
2 votes196 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
1 vote209 views2 answers
Sql queries practice
SQL
3 votes196 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote173 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote199 views4 answers
Open mysql port bitnami tomact
SQL
2 votes190 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL