The INFORMATION_SCHEMA.TABLE_CONSTRAINTS Table : INFORMATION_SCHEMA : Data Dictionary MySQL TUTORIALS


MySQL TUTORIALS » Data Dictionary » INFORMATION_SCHEMA »

 

The INFORMATION_SCHEMA.TABLE_CONSTRAINTS Table


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.




Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Data Dictionary
» INFORMATION_SCHEMA