The Information Schema TABLE_CONSTRAINTS table contains information about tables that have constraints.
It has the following columns:
| Column | Description |
|---|---|
CONSTRAINT_CATALOG |
Always def. |
CONSTRAINT_SCHEMA |
Database name containing the constraint. |
CONSTRAINT_NAME |
Constraint name. |
TABLE_SCHEMA |
Database name. |
TABLE_NAME |
Table name. |
CONSTRAINT_TYPE |
Type of constraint; one of UNIQUE, PRIMARY KEY or FOREIGN KEY. |
The REFERENTIAL_CONSTRAINTS table has more information about foreign keys.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/information-schema-table_constraints-table/