DDL for the Department Table | Basic Teradata Query - DDL for the Department Table - Basic Teradata Query

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