/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 vote258 views1 answer
How to find unique key in sql
SQL
18 votes253 views2 answers
Sql inner join
SQL
0 vote253 views1 answer
Mysql workbench not showing schemas
SQL
0 vote279 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote269 views1 answer
Open postgresql.conf in centos
SQL
0 vote260 views1 answer
Using GROUP BY in MySQL Join Table
SQL
0 vote255 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote260 views1 answer
Postgresql default value boolean
SQL
26 votes270 views2 answers
Mysql workbench download
SQL
10 votes284 views2 answers
Mysql remove only_full_group_by permanently
SQL