DDL for the Project Table | Basic Teradata Query - DDL for the Project Table - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.ditamap
dita:ditavalPath
obe1474387269547.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 )
;