Data Type Codes | HELP Statement | Teradata Vantage - Data Type Codes - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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