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.
Read syntax diagramSkip visual syntax diagram
Single-Column Constraint Format

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

Notes:
  1. Informix® extension
  2. 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.

Constraints that you define on temporary tables are always enabled.


Copyright© 2018 HCL Technologies Limited