17.10 - 例: HELP TABLE - Advanced SQL Engine - Teradata Database

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
2021年7月
Content Type
プログラミング リファレンス
Publication ID
B035-1144-171K-JPN
Language
日本語 (日本)

department表は次のように定義されています。

     CREATE TABLE personnel.department (
       dept_no   SMALLINT NOT NULL,
       dept_name VARCHAR(12) CHARACTER SET UNICODE,
       loc       CHARACTER(8) CHARACTER SET UNICODE,
       mgr_no    INTEGER NOT NULL)
     UNIQUE PRIMARY INDEX (dept_no);

以下のリクエストは、department表についての情報を返します。

     HELP TABLE personnel.department;
                    Column Name dept_no
                           Type I2
                        Comment Department number
                       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 ?
                 Character Type ?
                     IDCol Type ?
                       UDT Name ?
                       Temporal N
         Column Dictionary Name dept_no
                Column SQL Name dept_no
            Column Name UEscape
               Dictionary Title
                      SQL Title
                  Title UEscape
                    Column Name dept_name
                           Type CV
                        Comment Department name
                       Nullable N
                         Format X(12)
                          Title ?
                     Max Length 8
           Decimal Total Digits ?
      Decimal Fractional Digits ?
                      Range Low ?
                     Range High ?
                      Uppercase N
                    Table/View? T
                  Default Value ?
                 Character Type  2
                     IDCol Type ?
                       UDT Name ?
                       Temporal N
         Column Dictionary Name dept_name
                Column SQL Name dept_name
            Column Name UEscape
               Dictionary Title
                      SQL Title
                  Title UEscape
                    Column Name loc
                           Type CF
                        Comment Department location
                       Nullable N
                         Format X(18)
                          Title ?
                     Max Length 18
           Decimal Total Digits ?
      Decimal Fractional Digits ?
                      Range Low ?
                     Range High ?
                      Uppercase N
                    Table/View? T
                  Default Value ?
                 Character Type  2
                     IDCol Type ?
                       UDT Name ?
                       Temporal N
         Column Dictionary Name loc
                Column SQL Name loc
            Column Name UEscape
               Dictionary Title
                      SQL Title
                  Title UEscape
                    Column Name mgr_no
                           Type I
                        Comment Employee number of department manager
                       Nullable N
                         Format -(10)9
                          Title ?
                     Max Length ?
           Decimal Total Digits ?
      Decimal Fractional Digits ?
                      Range Low ?
                     Range High ?
                      Uppercase ?
                    Table/View? T
                       Indexed? Y
                        Unique? Y
                  Default Value ?
                 Character Type ?
                     IDCol Type ?
                       UDT Name ?
                       Temporal N
         Column Dictionary Name mgr_no
                Column SQL Name mgr_no
            Column Name UEscape
               Dictionary Title
                      SQL Title
                  Title UEscape