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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-73
Examples of SHOWDDL
NAME FIGARO_DATA_ZSDADM53_VZBRLI00
-- HASH PARTITION
-- (
-- The following partition is offline --
-- ADD LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1200
-- NAME FIGARO_$DATA_ZSDWWWWW_AADZ1200
-- )
STORE BY (B ASC, C DESC)
;
>>showddl t1;
CREATE TABLE CAT.SCH.T1
(
C1 INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C2 INT NO DEFAULT -- NOT NULL NOT DROPPABLE
, C3 INT DEFAULT NULL
, CONSTRAINT CAT.SCH.T1_104871911_0089
PRIMARY KEY (C1 ASC, C2 ASC) NOT DROPPABLE
, CONSTRAINT CAT.SCH.T1_104871911_0088 CHECK
(CAT.SCH.T1.C1 IS NOT NULL AND
CAT.SCH.T1.C2 IS NOT NULL) NOT DROPPABLE
)
LOCATION \FIGARO.$DATA.ZSDADM53.QUSGEI00
NAME FIGARO_DATA_ZSDADM53_QUSGEI00
PARTITION
(
ADD FIRST KEY (1200)
LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1400
-- The following partition is offline --
-- ADD FIRST KEY (1300)
-- LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1600
-- NAME FIGARO_$DATA_ZSDWWWWW_AADZ1600
, ADD FIRST KEY (1500)
LOCATION \FIGARO.$DATA.ZSDWWWWW.AADZ1200
NAME FIGARO_$DATA_ZSDWWWWW_AADZ1200
)
STORE BY (C1 ASC, C2 ASC)
;
•
This is an example of SHOWDDL on an SQL/MP table. By default, SQL/MX syntax
is used to output the DDL of the table, and file names are not fully qualified.
>>CREATE TABLE T1 (name CHAR(10) DEFAULT 'nobody'
HEADING 'NAME',
SID LARGEINT NOT NULL,
PRIMARY KEY (SID DESC),
SSN INT UNSIGNED NOT NULL,
birthdate DATE NOT NULL
)
PARTITION (
\FIGARO.$DATA14.DEANCAT.T1
EXTENT 32
MAXEXTENTS 300
FIRST KEY 5000)