SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Clauses
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
7-5
Examples of DEFAULT
•
The following example uses DEFAULT clauses on CREATE TABLE to specify
default column values:
CREATE TABLE persnl.project
( projcode NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL
,projdesc VARCHAR (18)
DEFAULT NULL
,start_date DATE
DEFAULT CURRENT_DATE
,ship_timestamp TIMESTAMP
DEFAULT CURRENT_TIMESTAMP
,est_complete INTERVAL DAY
DEFAULT INTERVAL '30' DAY
,PRIMARY KEY (projcode)) ;