Documentation / Commands / SHOW REFERENCES

SHOW REFERENCES

Core command SHOW REFS SH REF SHREF

Shows the foreign keys of other tables that reference a table

Arguments

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

Examples

SHOW REFERENCES CUSTOMER;

Notes

Lists the foreign keys of other tables that reference a table: SHOW REFERENCES <table>.

The inverse of SHOW FK: one row per column of each foreign key pointing to this table, with the referencing table, the constraint name, the column position within the key (#), the referencing column and the column of this table it references. A referencing table in another schema is shown qualified. A table that references itself appears too.

Table names are resolved as for SHOW FK. Reports that nothing references the table when no foreign key does. 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.