MySQL with foreign keys

Query for tables with foreign keys
Copy Code
Query specifies table foreign KEY constraints
Select
A.name as constraint name,
object_name (b.parent_object_id) as foreign key table,
D.name as foreign key column,
object_name (b.referenced_object_id) as main health watch,
C.name as primary key columns
From Sys.foreign_keys A
INNER JOIN Sys.foreign_key_columns B on a.object_id=b.constraint_object_id
INNER JOIN Sys.columns C on b.parent_object_id=c.object_id and b.parent_column_id=c.column_id
INNER JOIN Sys.columns D on b.referenced_object_id=d.object_id and b.referenced_column_id=d.column_id
where object_name (b.referenced_object_id) = ' table name to query ';

MySQL with foreign keys