Creating a Column Check Constraint

A column check constraint enforces a specified condition on a column. Add a column check constraint to a table using the Create Constraint Wizard.

Prerequisites

Database Version	Table Constraint Privileges
SAP Sybase IQ 15.3 and 15.4	Requires one of: DBA authority. ALTER permission on the underlying table. You own the underlying table.
SAP Sybase IQ 16.0	Requires one of: ALTER ANY OBJECT system privilege. ALTER ANY TABLE system privilege. You have ALTER permission on the underlying table. You own the underlying table.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables or Global Temporary Tables, select the table in the right pane, click the drop-down arrow that appears to the right, and select Properties.
Select Constraints.
Click New.
The Create Constraint Wizard appears.
On the Welcome page, specify a column check constraint:

Option Description

Select the type of constraint From the Select an item pull-down, select Column check constraint.
Click Next.

Option	Description
Select the type of constraint	From the Select an item pull-down, select Column check constraint.

On the Constraint Name page, specify:

Option	Description
What do you want to name the new column check constraint?	Specify a descriptive name for the column check constraint.
For which column do you want to create the new check constraint?	Filter the Name, Primary Key, Data Type, Size, and Scale columns to locate the desired column. Select a single column you want to create the constraint on.

Click Next.
On the Definition page, specify:

Option Description

Specify a condition to restrict the values. SQL definition of the check constraint.
Use this example as a model when specifying a definition:
```
CHECK(TerminationDate >= StartDate);
```
This example adds a constraint on the Employees table to ensure that the TerminationDate is always later than, or equal to, the StartDate.
Click Finish to close the Create Constraint Wizard.
The Properties view appears.
Tip: Although you closed the Create Constraint Wizard, the constraint is still in-progress until you click Apply and OK in step 12. If there is a problem with the constraint definition, modify the in-progress constraint by clicking Properties and then making the necessary SQL changes.
Click Apply and OK.