15.10 - Example: HELP COLUMN for Temporal Columns - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 ?