Online Documentation for SQL Manager for InterBase/Firebird

Creating/editing check

The Check section of the Constraints dialog allows you to specify CHECK constraint definition.

Name

Name of the CHECK constraint; the constraint name must be unique within the table.

Check Constraint Text

Set CHECK constraints, i.e. conditions that must be true for inserts and updates to the table, e.g.

PERCENT_CHANGE BETWEEN -50 AND 50

An attempt to enter a new value in the table fails if the value does not meet the specified check condition.

For your convenience the syntax highlight, code folding and a number of other features for efficient SQL editing are implemented. For details see Working with query and Using the context menu.