SQL Statements › CREATE TABLE › Column Definition

Column Definition

Following is the syntax diagram for the column definition:

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

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

Note: SYSTEM USER is a CA Datacom/DB extension.