Information Schema TABLE_CONSTRAINTS Table

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`, `FOREIGN KEY` or `CHECK`.

The REFERENTIAL_CONSTRAINTS table has more information about foreign keys.

Comments

Comments loading...

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ Information Schema Tables ↑
Information Schema InnoDB Tables
Information Schema MyRocks Tables
Information Schema XtraDB Tables
ColumnStore Information Schema Tables
Information Schema ALL_PLUGINS Table
Information Schema APPLICABLE_ROLES Table
Information Schema CATALOG Table
Information Schema CHARACTER_SETS Table
Information Schema CHECK_CONSTRAINTS Table
Information Schema CLIENT_STATISTICS Table
Information Schema COLLATION_CHARACTER_SET_APPLICABILITY Table
Information Schema COLLATIONS Table
Information Schema COLUMN_PRIVILEGES Table
Information Schema COLUMNS Table
Information Schema DISKS Table
Information Schema ENABLED_ROLES Table
Information Schema ENGINES Table
Information Schema EVENTS Table
Information Schema FEEDBACK Table
Information Schema FILES Table
Information Schema GEOMETRY_COLUMNS Table
Information Schema GLOBAL_STATUS and SESSION_STATUS Tables
Information Schema GLOBAL_VARIABLES and SESSION_VARIABLES Tables
Information Schema INDEX_STATISTICS Table
Information Schema KEY_CACHES Table
Information Schema KEY_COLUMN_USAGE Table
Information Schema KEY_PERIOD_USAGE Table
Information Schema KEYWORDS Table
Information Schema LOCALES Table
Information Schema METADATA_LOCK_INFO Table
Information Schema MROONGA_STATS Table
Information Schema OPTIMIZER_TRACE Table
Information Schema PARAMETERS Table
Information Schema PARTITIONS Table
Information Schema PERIODS Table
Information Schema PLUGINS Table
Information Schema PROCESSLIST Table
Information Schema PROFILING Table
Information Schema QUERY_CACHE_INFO Table
Information Schema QUERY_RESPONSE_TIME Table
Information Schema REFERENTIAL_CONSTRAINTS Table
Information Schema ROUTINES Table
Information Schema SCHEMA_PRIVILEGES Table
Information Schema SCHEMATA Table
Information Schema SEQUENCES Table
Information Schema SLAVE_STATUS Table
Information Schema SPATIAL_REF_SYS Table
Information Schema SPIDER_ALLOC_MEM Table
Information Schema SPIDER_WRAPPER_PROTOCOLS Table
Information Schema SQL_FUNCTIONS Table
Information Schema STATISTICS Table
Information Schema SYSTEM_VARIABLES Table
Information Schema TABLE_CONSTRAINTS Table
Information Schema TABLE_PRIVILEGES Table
Information Schema TABLE_STATISTICS Table
Information Schema TABLES Table
Information Schema TABLESPACES Table
Information Schema THREAD_POOL_GROUPS Table
Information Schema THREAD_POOL_QUEUES Table
Information Schema THREAD_POOL_STATS Table
Information Schema THREAD_POOL_WAITS Table
Information Schema TRIGGERS Table
Information Schema USER_PRIVILEGES Table
Information Schema USER_STATISTICS Table
Information Schema USER_VARIABLES Table
Information Schema USERS Table
Information Schema VIEWS Table
Information Schema WSREP_MEMBERSHIP Table
Information Schema WSREP_STATUS Table

Information Schema TABLE_CONSTRAINTS Table

Comments

Products

Services

Pricing

Resources

About Us

Download MariaDB