Numeric Data Types

Numeric Data Types

Data TypeMin ValueMax ValueMemory
INT−2^312^31−14 bytes
SMALLINT−2^152^152 bytes
BIGINT−2^632^63−18 bytes
TINYINT02551 byte
DECIMAL−10^38+110^381−15 to 17 bytes
MONEY−922,337, 203, 685,477.5808+922,337, 203, 685,477.58078 bytes
FLOAT−1.79E+3081.79E+308depends on float precision
REAL−3.40E+383.40E+384 bytes