17.10 - Integer Data Types - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Design

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-1094-171K
Language
English (United States)
BYTEINT: 1 Byte (All Platforms)
Bit 0 Bits 1 - 7
Sign -128  —  +127
SMALLINT: 2 Bytes (All Platforms)
Bit 0 Bits 1 - 15
Sign -32,768  —  +32,767
INTEGER: 4 Bytes (All Platforms)
Bit 0 Bits 1 - 31
Sign -2,147,483,648  —  +2,147,483,647
BIGINT: 8 Bytes (All Platforms)
Bit 0 Bits 1 - 63
Sign -9,223,372,036,854,775,808  —  +9,223,372,036,854,775,807

The following table indicates the alignment requirements for each of the true integer numeric data types and their respective sizes on packed64 and aligned row format systems:

Data Type Alignment Packed64 Size (bytes) Aligned Row Format\           Size (bytes)
BYTEINT        1        1        1
SMALLINT        2        2        2
INTEGER        4        4        4
BIGINT        8        8        8