TABLE_CONSTRAINTS table describes
which tables have constraints.
TABLE_CONSTRAINTS has these columns:
The value of this column is always
The name of the schema to which the constraint belongs.
The name of the schema to which the table belongs.
The name of the table.
PRIMARY KEYinformation is about the same as what you get from the
Key_namefield in the output from
SHOW INDEXwhen the