टेबल कॉलम के सभी फॉरेन की कैसे देखें?

INFORMATION_SCHEMA.KEY_COLUMN_USAGE से फॉरेन की जानकारी लें।

सेटअप

CREATE TABLE ForeignTable (id INT, name VARCHAR(200), Fk_pk INT);
CREATE TABLE primaryTable1 (Fk_pk INT, DeptName VARCHAR(200), PRIMARY KEY(Fk_pk));
ALTER TABLE ForeignTable ADD CONSTRAINT constFKPK FOREIGN KEY (Fk_pk) REFERENCES primaryTable1(Fk_pk);

टेबल के सभी फॉरेन की

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME,
       REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_NAME = 'primarytable1';

कॉलम-विशिष्ट

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME,
       REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE REFERENCED_TABLE_SCHEMA = 'business'
  AND REFERENCED_TABLE_NAME = 'primarytable1'
  AND REFERENCED_COLUMN_NAME = 'fk_pk';

आउटपुट

+--------------+-------------+-----------------+-----------------------+------------------------+
| TABLE_NAME   | COLUMN_NAME | CONSTRAINT_NAME | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME |
+--------------+-------------+-----------------+-----------------------+------------------------+
| foreigntable | Fk_pk       | constFKPK       | primarytable1         | fk_pk                  |
+--------------+-------------+-----------------+-----------------------+------------------------+