Single-Column Constraint Format

Use the single-column constraint format to create one or more data-integrity constraints for a single column in a temporary table.

Single-Colum Constraint Format:
 
|--NOT NULL--+-+-UNIQUE----------+---+--------------------------|
             | |  (1)            |   |
             | +--------DISTINCT-+   |
             | '-PRIMARY KEY-----'   |
             |                  (2)  |
             '-| CHECK Clause |------'
 

1. Informix extension
2. See page CHECK Clause

This is a subset of the syntax of Single-Column Constraint Format that the CREATE TABLE statement supports.

You can find detailed discussions of specific constraints in these sections.

Constraint

For more information, see

CHECK

CHECK Clause

DISTINCT

Using the UNIQUE or DISTINCT Constraints

NOT NULL

Using the NOT NULL Constraint

PRIMARY KEY

Using the PRIMARY KEY Constraint

UNIQUE

Using the UNIQUE or DISTINCT Constraints

Constraints that you define on temporary tables are always enabled.