sysforeignkey system table

Each row in the sysforeignkey system table describes a foreign key that belongs to a table.

Column name Column type Description
table_id UNSIGNED INTEGER The identifier of the table to which the foreign key belongs.
foreign_table_id UNSIGNED SHORT The identifier of the table to which this foreign-key-column refers to.
foreign_key_id UNSIGNED INTEGER The identifier of the foreign key.
name VARCHAR(128) The name of the foreign key.
index_name VARCHAR(128) The name of the index the foreign key refers to.
 Constraints