SELECT<\/p>\n
K_Table = FK.TABLE_NAME,<\/p>\n
FK_Column = CU.COLUMN_NAME,<\/p>\n
PK_Table = PK.TABLE_NAME,<\/p>\n
PK_Column = PT.COLUMN_NAME,<\/p>\n
Constraint_Name = C.CONSTRAINT_NAME<\/p>\n
FROM<\/p>\n
INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C<\/p>\n
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK<\/p>\n
ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME<\/p>\n
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK<\/p>\n
ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME<\/p>\n
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU<\/p>\n
ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME<\/p>\n
INNER JOIN (<\/p>\n
SELECT<\/p>\n
i1.TABLE_NAME,<\/p>\n
i2.COLUMN_NAME<\/p>\n
FROM<\/p>\n
INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1<\/p>\n
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2<\/p>\n
ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME<\/p>\n
WHERE<\/p>\n
i1.CONSTRAINT_TYPE = ‘PRIMARY KEY’<\/p>\n
) PT<\/p>\n
ON PT.TABLE_NAME = PK.TABLE_NAME<\/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":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-617","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\/617","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=617"}],"version-history":[{"count":1,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/617\/revisions"}],"predecessor-version":[{"id":618,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/617\/revisions\/618"}],"wp:attachment":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}