/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 vote295 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote105 views1 answer
Mysql max number not returning correct value
SQL
3 votes162 views2 answers
Savepoint in sql
SQL
2 votes106 views1 answer
Add default sql server
SQL
0 vote103 views1 answer
Select all columns except one sql
SQL
13 votes134 views4 answers
Mysql remove foreign key constraint
SQL
1 vote104 views1 answer
Load sql into mamp
SQL
0 vote110 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
7 votes99 views6 answers
Group_concat mysql
SQL
0 vote99 views1 answer
Kill thread
SQL