/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 vote217 views1 answer
Sql mod even odd
SQL
0 vote204 views2 answers
Mysql multiply
SQL
0 vote172 views1 answer
Query for maximum salary
SQL
0 vote229 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote202 views1 answer
Exclude last comma separated string mysql
SQL
38 votes282 views6 answers
Ubuntu install mysql client
SQL
0 vote211 views1 answer
Mysql check datetime equals date
SQL
2 votes219 views1 answer
ADD COLOUNS CREATED AND UPDATED AT IN MYSQL
SQL
-1 vote220 views1 answer
Capitole toulouse
SQL
0 vote247 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL