DDL for the Department Table

Basic Teradata Query Reference

brand
Teradata Tools and Utilities
prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K
CREATE SET TABLE workforce.department
  , FALLBACK
  , NO BEFORE JOURNAL
  , NO AFTER JOURNAL
  , CHECKSUM = DEFAULT
  , DEFAULT MERGEBLOCKRATIO
(
    DeptNo    SMALLINT
                FORMAT '999'
                CHECK ( (DeptNo >=  100 ) AND  (DeptNo <=  900 ) )
                NOT NULL
  , DeptName  VARCHAR(14)
                CHARACTER SET LATIN NOT CASESPECIFIC
  , Loc       CHAR(3)
                CHARACTER SET LATIN NOT CASESPECIFIC
  , MgrNo     SMALLINT
                FORMAT '9(5)'
                CHECK ( (MgrNo >=  10001 ) AND  (MgrNo <=  32001 ) )
                NOT NULL
)
UNIQUE PRIMARY INDEX ( DeptNo )
;