Table of Contents
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;