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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-75
Examples of SHOWDDL
--- 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;
>>SHOWDDL T1, SQLMP
CREATE TABLE \FIGARO.$DATA17.DEANCAT.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)
)
CATALOG \FIGARO.$DATA17.DEANCAT
PARTITION (
\FIGARO.$DATA14.DEANCAT.T1
FIRST KEY 5000
)
;
CREATE CONSTRAINT C1 on \FIGARO.$DATA17.DEANCAT.T1 CHECK SID
> 1000;
•
This is an example of SHOWDDL on a table with a trigger. The DDL of the triggers
is shown, but the ALTER TRIGGER DISABLE statement is not displayed for
triggers that are disabled.
>>CREATE TABLE T074T3
(A INT NOT NULL, B INT, C CHAR(8), D INT, PRIMARY KEY(A));
>>CREATE TRIGGER BTR BEFORE UPDATE ON T074T3
REFERENCING OLD AS MYOLDROW,
NEW AS MYNEWROW WHEN (MYNEWROW.D > MYOLDROW.D)