/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

13 votes189 views4 answers
What is sql
SQL
10 votes189 views2 answers
SQL rounding numbers
SQL
0 vote177 views1 answer
Mysql earlier than date
SQL
13 votes248 views2 answers
Sqlite rename table
SQL
18 votes183 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
8 votes179 views1 answer
Oracle create datafile
SQL
0 vote178 views1 answer
Mysql in clausule string array
SQL
2 votes173 views1 answer
Sql server conection string
SQL
0 vote174 views2 answers
Imageview setimageresource null
SQL
0 vote200 views1 answer
Sql last time database was accessed
SQL