Department(部門)テーブルのDDL - Basic Teradata Query

Basic Teradata Query リファレンス

Product
Basic Teradata Query
Release Number
16.20
Published
2018年4月
Language
日本語
Last Update
2019-07-11
dita:mapPath
ja-JP/kil1527114222313.ditamap
dita:ditavalPath
ja-JP/kil1527114222313.ditaval
dita:id
B035-2414
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 )
;