The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table The  TABLESPACES_EXTENSIONS  table (available as of MySQL 8.0.21) provides information about tablespace attributes defined for primary storage engines. The  TABLESPACES_EXTENSIONS  table is reserved for future use. The  TABLESPACES_EXTENSIONS  table has these columns: The name of the tablespace. Tablespace attributes defined for the primary storage engine. Reserved for future use. The  TABLE_CONSTRAINTS  table describes which tables have constraints. The  TABLE_CONSTRAINTS  table has these columns: The name of the catalog to which the constraint belongs. This value is always  def . 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  UNIQUE ,  PRIMARY KEY ,  FOREIGN KEY , or (as of MySQL 8.0.16)  CHECK . This is a  CHAR  (not  ENUM ) column. The  UNIQUE  and  PRIMARY KEY  information is about the same as what you get from the  Key_name column in the output from  SHOW INDEX  when the  Non_unique  column is  0 . For  CHECK  constraints, the value is  YES  or  NO  to indicate whether the constraint is enforced. For other constraints, the value is always  YES . This column was added in MySQL 8.0.16. The  TABLE_CONSTRAINTS_EXTENSIONS  table (available as of MySQL 8.0.21) provides information about table constraint attributes defined for primary and secondary storage engines. 4831 26.3.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table 26.3.42 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table Note • TABLESPACE_NAME • ENGINE_ATTRIBUTE • CONSTRAINT_CATALOG • CONSTRAINT_SCHEMA • TABLE_SCHEMA • TABLE_NAME •The  CONSTRAINT_TYPE • ENFORCED