SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-100
Examples of CREATE TABLE
A INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, B INT DEFAULT NULL
, CONSTRAINT J1.SCH1.TAB2_378461764_1268 PRIMARY KEY
(A ASC) NOT DROPPABLE
, CONSTRAINT J1.SCH1.TAB2_753441764_1268 CHECK
(J1.SCH1.TAB2.A IS NOT NULL)
NOT DROPPABLE
)
LOCATION \CARNAG.$SARA.ZSDCL87P.H5V45W00
NAME CARNAG_SARA_ZSDCL87P_H5V45W00
ATTRIBUTES EXTENT (1024, 1024), MAXEXTENTS 16
PARTITION
(
ADD FIRST KEY (2)
LOCATION \CARNAG.$HIJO.ZSDCL87P.PT245W00
NAME CARNAG_HIJO_ZSDCL87P_PT245W00
EXTENT (1024, 1024) MAXEXTENTS 16
, ADD FIRST KEY (512)
LOCATION \CARNAG.$CHINA.ZSDCL87P.S1645W00
NAME CARNAG_CHINA_ZSDCL87P_S1645W00
EXTENT (1024, 1024) MAXEXTENTS 16
)
STORE BY (A ASC)
;
--- SQL operation complete.
>>
•
This example creates table mytable with hash partitions.
create table mytable
( col1 TIMESTAMP default current_timestamp not null
, col2 INT not null
, col3 VARCHAR (30)
, col4 SMALLINT not null
, PRIMARY KEY (col4, col1) )
location $VOL1
hash partition by (col4)
( add location $VOL2
, add location $VOL3
, add location $VOL4)
attribute
extent (1024, 1024),
maxextents 16
;
create unique index mytable_idx1 on mytable(col2, col1)
LOCATION $vol1
hash partition by (col2)
( add location $VOL2
, add location $VOL3
, add location $VOL4
, add location $VOL5)
;