====== 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;