DDL for the Project Table - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-02-20
dita:mapPath
kil1527114222313.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
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 )
;