SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-97
Examples of SHOWDDL
(
C1 ASC
)
LOCATION \FIGARO.$DATA2.ZSDUXXBK.B7VVVW00
NAME FIGARO_DATA2_ZSDQXXBK_B7VVVW00
ATTRIBUTES BLOCKSIZE 32768, MAXEXTENTS 600
;
•
The following example displays the Sequence Generator attributes for an
IDENTITY column:
>>showddl cat.sch.t1;
CREATE TABLE CAT.SCH.T1
(
SURROGATE_KEY LARGEINT GENERATED ALWAYS AS IDENTITY
(START WITH 99 INCREMENT BY 2 MAXVALUE 900 MINVALUE 50 NO
CYCLE)
LOCATION \NSK.$SYSTEM.ZSDGNCWF.G423GN00
-- NOT NULL NOT DROPPABLE
, B INT UNSIGNED NO DEFAULT
-- NOT NULL NOT DROPPABLE
, CONSTRAINT CAT.SCH.T1_344545289_4325 PRIMARY KEY
(SURROGATE_KEY ASC) NOT
DROPPABLE
, CONSTRAINT CAT.SCH.T1_482894289_4325 CHECK
(CAT.SCH.T1.SURROGATE_KEY IS NOT
NULL AND CAT.SCH.T1.B IS NOT NULL) NOT DROPPABLE
)
LOCATION \NSK.$DATA.ZSDGNCWF.HWD7GN00
NAME NSK_DATA_ZSDGNCWF_HWD7GN00
ATTRIBUTES ALIGNED FORMAT, BLOCKSIZE 4096
STORE BY (SURROGATE_KEY ASC)
;
•
This is an example of SHOWDDL on a view for which Similarity Check is enabled:
>>showddl cat.sch.v1;
CREATE VIEW CAT.SCH.V1 ENABLE SIMILARITY CHECK AS SELECT
CAT.SCH.T1.I, CAT.SCH.T1.J from CAT.SCH.T1;
•
This is an example of SHOWDDL on a view for which Similarity Check is disabled:
>>showddl cat.sch.v2;
CREATE VIEW CAT.SCH.V2 DISABLE SIMILARITY CHECK AS SELECT
CAT.SCH.T2.I, CAT.SCH.T2.J from CAT.SCH.T2;