16.20 - Data Type Codes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

The following table lists the data type codes reported by HELP statements and the data types they represent.

Data Type Code Data Type
++ TD_ANYTYPE
A1 ARRAY (one dimensional)
AN ARRAY (multidimensional)
I8 BIGINT
BO BINARY LARGE OBJECT
BF BYTE
BV BYTE VARYING
I1 BYTEINT
CF CHARACTER (fixed)
CV CHARACTER (varying)
CO CHARACTER LARGE OBJECT
D DECIMAL
DA DATE
F DOUBLE PRECISION

DOUBLE PRECISION, FLOAT, and REAL are different names for the same data type.

F FLOAT

FLOAT, DOUBLE PRECISION, and REAL are different names for the same data type.

I INTEGER
DY INTERVAL DAY
DH INTERVAL DAY TO HOUR
DM INTERVAL DAY TO MINUTE
DS INTERVAL DAY TO SECOND
HR INTERVAL HOUR
HM

INTERVAL HOUR TO MINUTE

HS INTERVAL HOUR TO SECOND
MI INTERVAL MINUTE
MS INTERVAL MINUTE TO SECOND
MO INTERVAL MONTH
SC INTERVAL SECOND
YR INTERVAL YEAR
YM INTERVAL YEAR TO MONTH
N NUMBER
D NUMERIC
PD PERIOD(DATE)
PT PERIOD(TIME(n))
PZ PERIOD(TIME(n) WITH TIME ZONE)
PS PERIOD(TIMESTAMP(n))
PM PERIOD(TIMESTAMP(n) WITH TIME ZONE)
F REAL

REAL, DOUBLE PRECISION, and FLOAT are different names for the same data type.

I2 SMALLINT
AT TIME
TS TIMESTAMP
TZ TIME WITH TIME ZONE
SZ TIMESTAMP WITH TIME ZONE
UT USER-DEFINED TYPE (all types)
XM XML