Neoview SQL Reference Manual (R2.4 SP2)

-- 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