SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Clauses
HP NonStop SQL/MX Reference Manual—523725-004
7-4
Examples of DEFAULT
Examples of DEFAULT
•
This example uses DEFAULT clauses on CREATE TABLE to specify default
column values:
CREATE TABLE items
( item_id CHAR(12) NO DEFAULT
,description CHAR(50) DEFAULT NULL
,num_on_hand INTEGER DEFAULT 0 NOT NULL
,PRIMARY KEY (item_id) NOT DROPPABLE );
•
This example uses DEFAULT clauses on CREATE TABLE to specify default
column values:
CREATE TABLE persnl.project
( projcode NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
,empnum NUMERIC (4) UNSIGNED
NO DEFAULT
NOT NULL NOT DROPPABLE
,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) NOT DROPPABLE );