DDL for the Department Table - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
hyz1479325149183.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities
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 )
;