EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

On-line Documentation

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 SQL Editor area 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.