The INFORMATION_SCHEMA.TABLE_CONSTRAINTS Table : INFORMATION_SCHEMA « Data Dictionary « MySQL Tutorial

1. MySQL Tutorial
2. Data Dictionary
3. INFORMATION_SCHEMA

The TABLE_CONSTRAINTS table describes which tables have constraints.

The CONSTRAINT_TYPE value can be UNIQUE, PRIMARY KEY, or FOREIGN KEY.

The CONSTRAINT_TYPE column can contain one of these values: UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK.