Online Documentation for SQL Manager for Oracle

Creating/editing check


Use the Check tab of Check Editor to create/edit a check constraint and specify its properties.

 

Name

Specify the name of the check to be created, or view the name of the check being edited. Note that the check name must be unique within its schema.

 

CheckBox System named

If this option is selected, Oracle will generate the check name automatically when compiling the check definition.

 

Schema

Use the drop-down list to specify the schema in which the check will be created.

 

Check Editor - Editing check definition

 

Table

Use the drop-down list to select the table for which the check is created.

 

The lower area represents the condition implied by the check constraint.

You can specify any logical expression that returns TRUE or FALSE based on the logical operators.

 

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

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar.