Teradata HELP TABLE Command

Teradata HELP TABLE Command

The Teradata HELP TABLE command displays the information regarding name, data type, and comment (if applicable), of all columns in particular table:


HELP TABLE Customer_Service.emp;

ColumnName	Type	Comment
emp_number	I	System assigned identification
mgr_emp_number	I
dept_number	I	Department employee works in
job_code	I	Job classification designation
l_name	CF	Employee surname
f_name	CV	Employee given name
hire_date	DA	Date employee was hired
birth_date	DA
sal_amt	D	Annual compensation amount

Data type Representations are as follows:

Type                Description

BF                     BYTE
BV                    VARBYTE

CF                     CHARACTER FIXED

CV                    CHARACTER VARIABLE

DA                    DATE

I1                     BYTEINT

I2                     SMALLINT

AT                     TIME

TS                     TIMESTAMP

D                      DECIMAL

I                       INTEGER