SHOW FK

Core command SHOW FOREIGN KEYS SH FK SHFK

Shows the foreign keys declared by a table and what they reference

Arguments

<table> (mandatory) a table name, optionally qualified with its schema

Examples

SHOW FK ORDERS;

Notes

Lists the foreign keys a table declares: SHOW FK <table>.

One row per column of each foreign key: the constraint name, the column position within the key (#), the column of this table, and the table and column it references. The rows of a composite foreign key follow each other in key order. A referenced table in another schema is shown qualified.

Use SHOW REFERENCES for the opposite direction (the foreign keys of other tables that point to this one). Table names are resolved as for DESCR (schema-qualified or current schema, tried as typed, then upper case, then lower case), and must match exactly.

Reports that the table declares no foreign keys when it has none. Fails with an error if no table name is given, if the table does not exist or is ambiguous, or if the JDBC driver cannot provide foreign key metadata.

Last modified in release 5.3.1.