例: テンポラル列を持つHELP TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 構文規則および例

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
2021年1月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/ncd1596241368722.ditamap
dita:ditavalPath
ja-JP/ncd1596241368722.ditaval
dita:id
B035-1144
Product Category
Software
Teradata Vantage

次の テーブル定義があるとします。

     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);

次の例は、BTEQを使用したdepartmentテーブルのHELP TABLEレポートを示しています。

     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