Describes the range and storage size of all integer datatypes.
Integer Datatypes |
Range |
Storage (in Bytes) |
|---|---|---|
bigint |
Whole numbers between –263 and +(263 – 1), inclusive (–9,233,372,036,854,775,808 and +9,233,372,036,854,775,807) |
8 |
int |
Whole numbers between –231 and +(231 – 1), inclusive (–2,147,483,648, and +2,147,483,647) |
4 |
smallint |
Whole numbers between –215 and +(215 – 1), inclusive (–32,768 and +32,767) |
2 |
tinyint |
Positive whole numbers between 0 and 255, inclusive |
1 |