HELP COLUMN with a PTI Table Column Example | Teradata Vantage - Example: HELP COLUMN with a PTI Table Column - Advanced SQL Engine - Teradata Database

Time Series Tables and Operations

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cxa1555383531762.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1208
lifecycle
previous
Product Category
Teradata Vantageā„¢

This HELP COLUMN statement displays the information for the TD_TIMEBUCKET column of the PTI table, TimeSeriesTab.

HELP COLUMN TimeSeriesTab.TD_TIMEBUCKET;

The HELP COLUMN output includes the attribute, Time Series Column Type, with a value of TB:

                  Column Name TD_TIMEBUCKET
                           Type I8
                       Nullable N
                         Format -(19)9
                     Max Length 8
           Decimal Total Digits ?
      Decimal Fractional Digits ?
                      Range Low ? 
                     Range High ?
                      UpperCase N
                    Table/View? T
                       Indexed? Y
                        Unique? N
                       Primary? P
                          Title ?
              Column Constraint ?
                      Char Type ?
                     IdCol Type ?
                       UDT Name ?
                Temporal Column N
       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 TD_TIMEBUCKET
                Column SQL Name TD_TIMEBUCKET
            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 ?
                     SchemaName ?
                  Inline Length ?
               Transform Length ?
        Time Series Column Type TB