Table Constraints

In this window, you can define table-level constraints, such as check constraints, to enforce complex rules and conditions on your data beyond what can be achieved with column-level constraints. You can add or delete table constraints using the + Add and X Delete Selected buttons.

You can configure the following for a table constraint:

• Name: The name of the table constraint key. You can edit the name by double-clicking the cell.

• Enabled: If this option is selected, then the table constraint will be enabled.

• Rely: If this option is selected, then the constraint can be relied upon.

• Deferrable: If this option is selected, then the constraint check can be deferred until the transaction is committed.

• Initially Immediate: If this option is selected, then the constraint is enforced immediately .

• Validate: If this option is selected, then data in the table must comply with the table constraint.

• Check Condition: Specify an expression or condition that must be met for all rows in the table. For example, to indicate that the value in a numeric column named RATING must be from 1 to 10, you can specify: rating >=1 and rating <= 10.

Once your table constraint configuration is complete, click Apply to save your changes.