Table of Contents
SHOW CHECKS
[NEW in v5.0]
SHOW CHECKS displays information about all CHECK constraints of a table defined for it and its fields.
Syntax
SHOW CHECKS {FROM|OF} table_name [{FROM|OF} db_name]
Result Columns
- fld_name
The name of the CHECK constraint.
- fld_enabled
Returns TRUE if this constraint enabled.
- fld_table_level
Returns TRUE if this constraint is on Table level. Returns FALSE if it is on Field level.
- fld_tmp
Returns TRUE if this constraint is temporary.
- fld_text
Text of the CHECK constraint.
Examples
SHOW CHECKS FROM tblPerson; SHOW CHECKS FROM tblPerson FROM dbAccounting;