/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

5 votes341 views3 answers
Mysql remove unique constraint
SQL
0 vote338 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote308 views1 answer
Is numeric in sql
SQL
7 votes345 views1 answer
Query postgres delete duplicates
SQL
0 vote345 views1 answer
How to write if case in select query in select statement
SQL
0 vote354 views1 answer
Sql date with year
SQL
0 vote334 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote335 views1 answer
Hoq to import database source
SQL
0 vote340 views1 answer
Sql last 3 rows
SQL
0 vote358 views1 answer
GROUP BY postgres
SQL