Example: HELP COLUMN for Temporal Columns - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

This example shows the report returned by a HELP COLUMN request on temporal columns.

Assume the following table definition.

 CREATE MULTISET TABLE department (
   deptname     VARCHAR(10),
   deptno       INTEGER NOT NULL UNIQUE CHECK(dept_no > 0),
   avgsalary    DECIMAL(9,2),
   deptduration PERIOD(DATE) NOT NULL AS VALIDTIME,
   depttran     PERIOD(TIMESTAMP(6) WITH TIME ZONE) AS TRANSACTIONTIME)
 PRIMARY INDEX (deptno);

The following report is an example of a HELP COLUMN request on the dept_tran column for this table.

     HELP COLUMN department.depttran;
     HELP COLUMN department.dept_tran;
      *** Help information returned. 5 rows.
Column Name  dept_tran
Type  PM
Nullable N
Format  YYYY-MM-DDBHH:MI:SS.S(6)Z
Max Length 24
Decimal Total Digits  ?
Decimal Fractional Digits  6
Range Low  ?
Range High  ?
UpperCase  N
Table/View?  T
Indexed?  N
Unique?  ?
Primary?  ?
Title  ?
Column Constraint  ?
Char Type  ?
IdCol Type  ?
UDT Name  ?
Temporal Column  T
Current ValidTime Unique  ?
Sequenced ValidTime Unique  ?
NonSequenced ValidTime Unique  ?
Current TransactionTime Unique  ?
Partitioning Column N
Column Partition Number 0
Column Partition Format NA
Column Partition AC NA
Security Constraint  N
Derived_UDT ?
Derived_UDTFieldID ?
Column Dictionary Name depttran
Column SQL Name depttran
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Database Dictionary Name ?
UDT Database SQL Name ?
UDT Database Name UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Without Overlaps Unique ?
Storage Format ?

The following report is an example of a HELP COLUMN request on the dept_no column in this table.

     HELP COLUMN department.dept_no;
     HELP COLUMN department.dept_no;
      *** Help information returned. One row.
      *** Total elapsed time was 1 second.
Column Name dept_no
Type I
Nullable N
Format -(10)9
Max Length  4
Decimal Total Digits  ?
Decimal Fractional Digits ?
Range Low ?
Range High ?
UpperCase N
Table/View? T
Indexed? Y
Unique? Y
Primary? S
Title ?
Column Constraint CURRENT VALIDTIME AND CURRENT TRANSACTIONTIME CHECK(deptno>0)
Char Type ?
IdCol Type ?
UDT Name ?
Temporal Column ?
Current ValidTime Unique ?
Sequenced ValidTime Unique ?
Nonsequenced ValidTime Unique ?
Current TransactionTime Unique ?
Partitioning Column N
Column Partition Number 0
Column Partition Format NA
Column Partition AC NA
Security Constraint N
Derived_UDT ?
Derived_UDTFieldID ?
Column Dictionary Name dept_no
Column SQL Name dept_no
Column Name UEscape ?
Dictionary Title ?
SQL Title ?
Title UEscape ?
UDT Database Dictionary Name ?
UDT Database SQL Name ?
UDT Database Name UEscape ?
UDT Dictionary Name ?
UDT SQL Name ?
UDT Name UEscape ?
Without Overlaps Unique ?
Storage Format ?