Switch to: V9V8V7V6V5

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;