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-Column Constraint Format

   .--------------------------.   
   V                          |   
|----+-+-+-NULL-----+---+---+-+---------------------------------|
     | | '-NOT NULL-'   |   |     
     | +-UNIQUE---------+   |     
     | |  (1)           |   |     
     | +-------DISTINCT-+   |     
     | '-PRIMARY KEY----'   |     
     |                  (2) |     
     '-| CHECK Clause |-----'

Notes:

Informix® extension
See 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 UNIQUE or DISTINCT Constraints
NOT NULL: Using the NOT NULL Constraint
NULL: Using the NULL Constraint
PRIMARY KEY: Using the PRIMARY KEY Constraint
UNIQUE: Using UNIQUE or DISTINCT Constraints

Constraints that you define on temporary tables are always enabled.