Teradata Datatypes Size

In Teradata it is actually very important to know what is the Storage size required by the different datatypes.If you know the storage requirement of different datatypes used in your tables in Database, you can compute space requirement easily.So storage requirement for few of the most common datatypes used in Teradata are :

BYTEINT – 1 BYTE
SMALLINT – 2 BYTES
INTEGER – 4 BYTES
BIGINT – 8 BYTESS
DECIMAL – 2 BYTES to 8 BYTES
FLOAT – 8 BYTES
DATE – 4 BYTES
TIME – 6 BYTES
TIME WITH ZONE – 8 BYTES
TIMESTAMP – 10 BYTES
TIMESTAMp WITH ZONE – 12 BYTES
These are few of the most common datatypes used in Teradata and their respective storage bytes required. The range for numeric datatypes can be calculated by formula 2(power of BYTES*8 -1).

Leave a Reply

Your email address will not be published. Required fields are marked *