Defining Constraints for Columns

Prerequisites

You are logged on to the database as a database user.
You have the ALTER privilege for the table to which the column belongs.

More information: SQL Reference Manual, Privilege Specification (priv_spec)
Columns have been created for the table already.
The database is in the ONLINE operational state.

A constraint for a column is an integrity condition that must be met by all column values.

Select the table in the explorer tree.
In the context menu of the table, choose Definition.
In the context menu of the editor window, choose Edit.
Open the Constraints tab page.
To define a new constraint, choose Add Constraint in the context menu of the editor window and enter the properties of the constraint.
To change the definition of a constraint, overwrite the corresponding property in the editor window.

More information:

SQL Reference Manual,
- Constraint Name (constraint_name)
- CONSTRAINT Definition (constraint_definition)
In the context menu of the editor window, choose Create Table (if you are creating a new table) or Alter Table (if the table already exists).