Example: HELP TABLE - Teradata Vantage

Definition of the department table:

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

Request that 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