17.00 - Example: HELP TABLE with Temporal Columns - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

Assume the following table definition.

     CREATE MULTISET TABLE department (
       deptname     VARCHAR(10) CHARACTER SET UNICODE,
       deptno       INTEGER NOT NULL UNIQUE,
       avg_salary    INTEGER,
       dept_duration PERIOD(DATE) AS VALIDTIME,
       dept_tran     PERIOD(TIMESTAMP(6) WITH TIME ZONE)
                            TRANSACTIONTIME)
     PRIMARY INDEX (deptno);

The following example shows the HELP TABLE report for the department table using BTEQ.

     HELP TABLE department;
      *** Help information returned. 5 rows.
Column Name deptname
                              Type CV
                           Comment ?
                          Nullable Y
                            Format X(10)
                             Title ?
                        Max Length           10
              Decimal Total Digits  ?
         Decimal Fractional Digits  ?
                         Range Low                   ?
                        Range High                   ?
                         UpperCase N
                       Table/View? T
                     Default value ?
                         Char Type  2
                        IdCol Type ?
                          UDT Name ?
                          Temporal N
            Column Dictionary Name deptname
                   Column SQL Name deptname
               Column Name UEscape
                  Dictionary Title
                         SQL Title
                     Title UEscape
                       Column Name deptno
                              Type I
                           Comment ?
                          Nullable N
                            Format -(10)9
                             Title ?
                        Max Length           4
              Decimal Total Digits ?
         Decimal Fractional Digits ?
                         Range Low                   ?
                        Range High                   ?
                         UpperCase N
                       Table/View? T
                     Default value ?
                         Char Type  ?
                        IdCol Type ?
                          UDT Name ?
                          Temporal N
            Column Dictionary Name deptno
                   Column SQL Name deptno
               Column Name UEscape
                  Dictionary Title
                         SQL Title
                     Title UEscape
                       Column Name avg_salary
                              Type I
                           Comment ?
                          Nullable Y
                            Format -(10)9
                             Title ?
                        Max Length            4
              Decimal Total Digits  ?
         Decimal Fractional Digits  ?
                         Range Low                   ?
                        Range High                   ?
                         UpperCase N
                       Table/View? T
                     Default value ?
                         Char Type  ?
                        IdCol Type ?
                          UDT Name ?
                 Column Constraint ?
                         Char Type ?
                        IdCol Type ?
                          UDT Name ?
                          Temporal ?
            Column Dictionary Name avg_salary
                   Column SQL Name avg_salary
               Column Name UEscape
                  Dictionary Title
                         SQL Title
                     Title UEscape
                       Column Name dept_duration
                              Type PD
                           Comment ?
                          Nullable N
                            Format YY/MM/DD
                             Title ?
                        Max Length            8
              Decimal Total Digits  ?
         Decimal Fractional Digits  ?
                         Range Low                   ?
                        Range High                   ?
                         UpperCase N
                       Table/View? T
                     Default value N
                         Char Type ?
                        IdCol Type ?
                          UDT Name ?
                          Temporal Y
            Column Dictionary Name dept_duration
                   Column SQL Name dept_duration
               Column Name UEscape
                  Dictionary Title
                         SQL Title
                     Title UEscape
                       Column Name dept_tran
                              Type PM
                           Comment ?
                          Nullable N
                            Format YYYY-MM-DDBHH:MI:SS.S(6)Z
                             Title ?
                        Max Length           24
              Decimal Total Digits  ?
         Decimal Fractional Digits  6
                         Range Low                   ?
                        Range High                   ?
                         UpperCase N
                       Table/View? T
                     Default value ?
                         Char Type  ?
                        IdCol Type ?
                          UDT Name ?
                          Temporal Y
            Column Dictionary Name dept_tran
                   Column SQL Name dept_tran
               Column Name UEscape
                  Dictionary Title
                         SQL Title
                     Title UEscape