SELECT
\n K_Table = FK.TABLE_NAME,
\n FK_Column = CU.COLUMN_NAME,
\n PK_Table = PK.TABLE_NAME,
\n PK_Column = PT.COLUMN_NAME,
\n Constraint_Name = C.CONSTRAINT_NAME
\nFROM
\n INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
\nINNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK
\n ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
\nINNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK
\n ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
\nINNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU
\n ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
\nINNER JOIN (
\n SELECT
\n i1.TABLE_NAME,
\n i2.COLUMN_NAME
\n FROM
\n INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
\n INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2
\n ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
\n WHERE
\n i1.CONSTRAINT_TYPE = ‘PRIMARY KEY’
\n ) PT
\n ON PT.TABLE_NAME = PK.TABLE_NAME<\/p>\n
—<\/p>\n
SELECT
\n o1.name AS FK_table,
\n c1.name AS FK_column,
\n fk.name AS FK_name,
\n o2.name AS PK_table,
\n c2.name AS PK_column,
\n pk.name AS PK_name,
\n fk.delete_referential_action_desc AS Delete_Action,
\n fk.update_referential_action_desc AS Update_Action
\nFROM sys.objects o1
\n INNER JOIN sys.foreign_keys fk
\n ON o1.object_id = fk.parent_object_id
\n INNER JOIN sys.foreign_key_columns fkc
\n ON fk.object_id = fkc.constraint_object_id
\n INNER JOIN sys.columns c1
\n ON fkc.parent_object_id = c1.object_id
\n AND fkc.parent_column_id = c1.column_id
\n INNER JOIN sys.columns c2
\n ON fkc.referenced_object_id = c2.object_id
\n AND fkc.referenced_column_id = c2.column_id
\n INNER JOIN sys.objects o2
\n ON fk.referenced_object_id = o2.object_id
\n INNER JOIN sys.key_constraints pk
\n ON fk.referenced_object_id = pk.parent_object_id
\n AND fk.key_index_id = pk.unique_index_id
\nORDER BY o1.name, o2.name, fkc.constraint_column_id<\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT K_Table = FK.TABLE_NAME, FK_Column = CU.COLUMN_NAME, PK_Table = PK.TABLE_NAME, PK_Column = PT.COLUMN_NAME, Constraint_Name = C.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME INNER JOIN ( SELECT i1.TABLE_NAME, i2.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1 INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME… Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-480","post","type-post","status-publish","format-standard","hentry","category-sql","xfolkentry"],"_links":{"self":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=480"}],"version-history":[{"count":0,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/480\/revisions"}],"wp:attachment":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=480"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}