HELP TABLE Examples | Teradata Vantage - 17.00 - Example: HELP TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

The definition of the department table is the following.

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

The following request returns information about the department table.

     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