SQL Statements › CREATE TABLE › Column Definition

Column Definition

Following is the syntax diagram for the column definition:

►►─ column-name ─ datatype ─┬────────────┬─┬─────────────────────────────┬───►
                            └─ UNSIGNED ─┘ └─ DEFAULT ─┬─ literal ─────┬─┘
                                                       ├─ NULL ────────┤
                                                       ├─ USER ────────┤
                                                       └─ SYSTEM USER ─┘

 ►─┬─────────────────────────┬────────────────────────────────────────────────►◄
   │ ┌─────────────────────┐ │
   └─▼─ column constraint ─┴─┘

Note:

SYSTEM USER is a CA Datacom/DB extension.