/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 vote146 views1 answer
FIND most frequent word in sql server
SQL
7 votes149 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote172 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote181 views2 answers
Uninstall postgresql mac
SQL
15 votes156 views2 answers
Select where duplicate mysql
SQL
4 votes139 views1 answer
Oracle session date format
SQL
15 votes154 views6 answers
Psql
SQL
-1 vote153 views1 answer
Sql syntax create timestamp column
SQL
0 vote148 views1 answer
Create new schema mysql
SQL
1 vote170 views1 answer
Sql server kill all connections
SQL