24.27 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
TABLE_CONSTRAINTS table describes which tables have constraints.
TABLE_CONSTRAINTS table has these columns:
The name of the catalog to which the constraint belongs. This value is always
The name of the schema (database) to which the constraint belongs.
The name of the schema (database) to which the table belongs.
The name of the table.
PRIMARY KEYinformation is about the same as what you get from the
Key_namecolumn in the output from
SHOW INDEXwhen the