15.00 - Data Type Codes - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

Data Type Codes

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