/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

1 vote227 views1 answer
Join to find results not in another table
SQL
2 votes214 views2 answers
Mysql all columns
SQL
2 votes227 views1 answer
How to add where command in update comand with joins
SQL
6 votes215 views1 answer
Rank function in oracle with example
SQL
5 votes225 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote232 views1 answer
Why we have to set the password for my sql server
SQL
6 votes226 views2 answers
Mysql check auto increment value
SQL
0 vote230 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote229 views1 answer
Mysql error 1251
SQL
1 vote236 views1 answer
Print all records of table in mysql
SQL