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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-74
Examples of SHOWDDL
NO AUDITCOMPRESS;
--- SQL operation complete.
>>CREATE INDEX IDXA on T1 CHECK SID > 1000;
--- SQL operation complete.
>>CREATE UNIQUE INDEX UIDX ON T1 (A);
--- SQL operation complete.
>>CREATE CONSTRAINT C1 on T1 CHECK SID > 1000;
--- 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)
, CONSTRAINT C1 CHECK (SID > 1000)
)
ATTRIBUTES NO AUDITCOMPRESS
LOCATION \FIGARO.$DATA17.DEANCAT.T1
PARTITION
(
ADD FIRST KEY (5000)
LOCATION \FIGARO.$DATA14.DEANCAT.T1
)
CREATE INDEX IDXA ON T1
(
A ASC
)
CATALOG \FIGARO.$DATA17.DEANCAT
KEYTAG 1
;
CREATE UNIQUE INDEX UIDX ON IXT
(
A ASC
)
CATALOG \FIGARO.$DATA17.DEANCAT
KEYTAG 2
;
CREATE CONSTRAINT C1 ON IXT
CHECK (A > 100) ;