/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 vote146 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote134 views2 answers
Database owner can't create new tables postgres
SQL
0 vote141 views3 answers
Sql delete all except
SQL
1 vote138 views1 answer
Oracle index partition
SQL
4 votes121 views1 answer
Search column by name mysql
SQL
4 votes96 views1 answer
Oracle sleep
SQL
0 vote160 views1 answer
SQL Where-Klausel
SQL
27 votes167 views5 answers
Mysql set password for user
SQL
1 vote140 views2 answers
How to drop a unique constraint in sql
SQL
1 vote128 views1 answer
Sql bitwise operators
SQL