/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

2 votes247 views2 answers
How to add not null constraint in sql
SQL
0 vote237 views1 answer
Sql show all users
SQL
1 vote231 views2 answers
Sql where is not number
SQL
0 vote186 views1 answer
Connection error in mysql workbench
SQL
0 vote219 views1 answer
Increment id in mysql
SQL
0 vote219 views1 answer
Database springboot
SQL
0 vote251 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote330 views1 answer
Oracle db timestamp auto add
SQL
7 votes254 views2 answers
Where keyword sql
SQL
0 vote230 views1 answer
Import sql inside hide sql
SQL