/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 vote222 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
2 votes172 views1 answer
Insert from table tsql
SQL
0 vote160 views1 answer
Redshift running queries
SQL
3 votes131 views1 answer
Sql select all
SQL
0 vote130 views1 answer
Running query in redshift
SQL
4 votes146 views2 answers
Oracle drop job
SQL
8 votes158 views1 answer
Show mysql user table
SQL
4 votes178 views1 answer
Postgresql change default value
SQL
0 vote144 views1 answer
Soql update query
SQL
5 votes129 views1 answer
Mysql get last day of month
SQL