TABLE_CONSTRAINTS table describes
which tables have constraints.
TABLE_CONSTRAINTS table has these
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.
The type of constraint. The value can be
FOREIGN KEY, or (as of MySQL 8.0.16)
CHECK. This is a
PRIMARY KEYinformation is about the same as what you get from the
Key_namecolumn in the output from
SHOW INDEXwhen the
CHECKconstraints, the value is
NOto indicate whether the constraint is enforced. For other constraints, the value is always
This column was added in MySQL 8.0.16.