/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 vote226 views1 answer
Ms sql - add one hour to time
SQL
1 vote283 views1 answer
Mysql change root mysql_native_password
SQL
1 vote338 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote246 views1 answer
Kannst du deine finger trainieren
SQL
17 votes352 views4 answers
Show all tables in oracle
SQL
0 vote311 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote289 views2 answers
Sqlite unique
SQL
5 votes285 views1 answer
Alter table add comment oracle
SQL
0 vote303 views1 answer
How to print some string in mysql
SQL
0 vote315 views1 answer
Manage Database in MySQL
SQL