Switch to: V9V8V7V6V5

SHOW CONSTRAINTS

[NEW in v5.0]

SHOW CONSTRAINTS displays information about all constraints of a table defined for it and its fields.

Syntax

SHOW CONSTRAINTS {FROM|OF} table_name [{FROM|OF} db_name]

Result Columns

  • fld_name

The name of the CHECK constraint.

  • fld_kind

Specifies the kind of constraint.

  • fld_field_names

  • fld_enabled

TRUE if this constraint is enabled.

  • fld_table_level

Returns TRUE if this constraint is on Table level. Returns FALSE if it is on Field level.

  • fld_tmp

TRUE if this constraint is temporary.

  • fld_index_name

If this constraint uses some index, then this field specifies its name.

  • fld_max_value

The ID of constraint.

  • fld_do_circle

The ID of constraint.

Examples

SHOW CONSTRAINTS FROM tblPerson;
SHOW CONSTRAINTS FROM tblPerson FROM dbAccounting;