SQL Statements › CREATE TABLE › Column Constraint Definition

Column Constraint Definition

Following is the syntax diagram for the column constraint definition:

►►─┬─ NOT NULL ─┬────────────────┬─┬───────────────┬───────────┬──────────────►
   │            └─ WITH DEFAULT ─┘ ├─ PRIMARY KEY ─┤           │
   │                               └─ UNIQUE ──────┘           │
   ├─ REFERENCEStable-name ─┬──────────────────┬─┬───────────┬─┤
   │                        └─ (ref-col-name) ─┘ └─ ref-act ─┘ │
   └─ CHECK(search condition) ─────────────────────────────────┘

 ►─┬─────────────────────────────┬────────────────────────────────────────────►◄
   └─ CONSTRAINTconstraint-name ─┘

Note:

WITH DEFAULT is a CA Datacom/DB extension.