SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Clauses
HP NonStop SQL/MX Reference Manual—544517-008
7-4
Examples of DEFAULT
See CREATE TABLE Statement on page 2-77.
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 );
column data-type
NOT NULL NOT DROPPABLE
No default.
column data-type
NOT NULL
Default null when NOT_NULL_
CONSTRAINT_DROPPABLE_OPTION is
set to ON.
column data-type
NOT NULL
No default when NOT_NULL_
CONSTRAINT_DROPPABLE_OPTION is
set to OFF (the default).