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

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-78
Examples of SHOWDDL
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
)
EXTENT 48
MAXEXTENTS 300
PARTITION (
\FIGARO.$DATA14.DEANCAT.T1
FIRST KEY (5000),
\FIGARO.$DATA15.DEANCAT.T1
EXTENT 48
MAXEXTENTS 300
FIRST KEY (10000))
NO AUDITCOMPRESS;
--- SQL operation complete.
>>CREATE INDEX IDXA on T1 (SID)
PARTITION (\FIGARO.$DATA14.DEANCAT.IDXA FIRST KEY(100),
\FIGARO.$DATA15.DEANCAT.IDXA FIRST KEY (1000));
--- SQL operation complete.
>>CREATE UNIQUE INDEX UIDX ON T1 (SSN);
--- SQL operation complete.
>>CREATE CONSTRAINT C1 on T1 CHECK (NAME >"AAA");
--- SQL operation complete.
>>SHOWDDL T1;
CREATE TABLE T1
(
NAME CHAR(10) CHARACTER SET ISO88591 COLLATE
DEFAULT DEFAULT 'NOBODY' HEADING 'NAME'
, SID LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
, SSN INT UNSIGNED NO DEFAULT NOT NULL NOT DROPPABLE
, BIRTHDATE DATE NO DEFAULT NOT NULL NOT DROPPABLE
, PRIMARY KEY (SID DESC)
)
LOCATION \FIGARO.$DATA17
ATTRIBUTES NO AUDITCOMPRESS