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

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-79
Examples of SHOWDDL
, EXTENT (48, 48),MAXEXTENTS 300
PARTITION
(
ADD FIRST KEY (10000)
LOCATION \FIGARO.$DATA14
, ADD FIRST KEY (5000)
LOCATION \FIGARO.$DATA15
)
;
CREATE INDEX IDXA ON T1
(
SID ASC
)
LOCATION \FIGARO.$DATA17
PARTITION
(
ADD FIRST KEY (100)
LOCATION \FIGARO.$DATA14
, ADD FIRST KEY (1000)
LOCATION \FIGARO.$DATA15
)
ATTRIBUTES NO AUDITCOMPRESS
;
CREATE UNIQUE INDEX UIDX ON T1
(
SSN ASC
)
LOCATION \FIGARO.$DATA17
ATTRIBUTES NO AUDITCOMPRESS
;
ALTER TABLE T1
ADD CONSTRAINT C1 CHECK (NAME >'AAA') ;
--- SQL operation complete.
•
This is an example of SHOWDDL on an SQL/MP table using the SQLMP syntax
option. File names are shown 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)
NO AUDITCOMPRESS;
>>CREATE CONSTRAINT C1 on T1 CHECK SID > 1000;