Documentation Home
MySQL Information Schema
Related Documentation Download this Excerpt
PDF (US Ltr) - 0.7Mb
PDF (A4) - 0.7Mb


MySQL Information Schema  /  INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table

4.43 The INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS Table

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.

Note

The TABLE_CONSTRAINTS_EXTENSIONS table is reserved for future use.

The TABLE_CONSTRAINTS_EXTENSIONS table has these columns:

  • CONSTRAINT_CATALOG

    The name of the catalog to which the table belongs.

  • CONSTRAINT_SCHEMA

    The name of the schema (database) to which the table belongs.

  • CONSTRAINT_NAME

    The name of the constraint.

  • TABLE_NAME

    The name of the table.

  • ENGINE_ATTRIBUTE

    Constraint attributes defined for the primary storage engine. Reserved for future use.

  • SECONDARY_ENGINE_ATTRIBUTE

    Constraint attributes defined for the secondary storage engine. Reserved for future use.