Project(プロジェクト)テーブルのDDL - Basic Teradata Query

Basic Teradata Queryリファレンス

Product
Basic Teradata Query
Release Number
16.20
Published
2018年4月
Language
日本語
Last Update
2019-07-03
dita:mapPath
ja-JP/moy1512703123963.ditamap
dita:ditavalPath
ja-JP/moy1512703123963.ditaval
dita:id
B035-2414
Product Category
Teradata Tools and Utilities
CREATE SET TABLE workforce.project
  , FALLBACK
  , NO BEFORE JOURNAL
  , NO AFTER JOURNAL
  , CHECKSUM = DEFAULT
  , DEFAULT MERGEBLOCKRATIO
(
    Proj_Id      CHAR(8)
                   CHARACTER SET LATIN NOT CASESPECIFIC
                   TITLE 'Project//  Id'
                   NOT NULL
  , Description  VARCHAR(25)
                   CHARACTER SET LATIN NOT CASESPECIFIC
                   TITLE '  Project Description'
  , RecDate      DATE
                   FORMAT 'YY/MM/DD'
                   TITLE 'Received//Date'
  , DueDate      DATE
                   FORMAT 'YY/MM/DD'
                   TITLE 'Due //Date'
  , ComDate      DATE
                   FORMAT 'YY/MM/DD'
                   TITLE 'Compl//Date'
)
UNIQUE PRIMARY INDEX ( Proj_Id )
;