Online Documentation for SQL Manager for InterBase/Firebird

Setting field check


The Check page allows you to set CHECK constraints, i.e. conditions that must be true for inserts and updates to the field, e.g. VALUE>=10 or MIN_SALARY < MAX_SALARY. An attempt to enter a new value in the column 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.

 

Note that the check value set for the field based on a domain in the Check section of Field Editor will override the corresponding value set for the domain.

 

Tables - Field Editor - Setting field checks

 

See Checks for details.