DDL for the Project Table - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K
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 )
;