Neoview SQL Reference Manual (R2.4)

-- showddl on materialized view
SHOWDDL EMPL_MV, PRIVILEGES
-- showddl output
CREATE MATERIALIZED VIEW SCH.EMPL_MV
AS SELECT max(SCH.EMPL.SALARY) AS SALARY, SCH.EMPL.DEPT_NO AS DEPT_NO
FROM SCH.EMPL GROUP BY SCH.EMPL.DEPT_NO;
-- The system added the following columns to the select list:
-- count(*) AS SYS_COUNTSTAR1
-- count(SCH.EMPL.SALARY) AS SYS_COUNT2
-- showddl on dept table
SHOWDDL DEPT, PRIVILEGES
-- showddl output
-- Schema level privileges
-- GRANT SELECT ON SCHEMA SCH TO “ROLE.READER”;
CREATE TABLE SCH.DEPT
(
DEPT_NO INT NO DEFAULT -- NOT NULL
, DEPT_NAME VARCHAR(20) CHARACTER SET ISO88591 NO DEFAULT -- NOT NULL
, CONSTRAINT SCH.DEPT_849937374_7746 PRIMARY KEY (DEPT_NO ASC)
, CONSTRAINT SCH.DEPT_985137374_7746 CHECK (SCH.DEPT.DEPT_NO IS NOT
NULL AND SCH.DEPT.DEPT_NAME IS NOT NULL)
)
HASH PARTITION BY (DEPT_NO)
SHOWDDL Statement 195