Integer Data Types

integers

Here is some examples of the integer data types. When deciding on a integer for a column, variable, parameter or expression it is a wise choice to choose the most efficient data type based off of size and usage. Click here to see examples of the four integer data types in use.

TINY INTEGER

tinyint

The tiny integer data type allows for whole numbers between 0 and 255 and only uses 1 byte of data.

SMALL INTEGER

smallintThe small integer data type allows for a whole number between -32678 to a positive value of 32767 and will consume 2 bytes of data.

REGULAR INTEGER

intdatatypeThe regular integer data type allows for a whole number between -2147483648 to a positive value 2147483647 and will consume 4 bytes of data.

BIG INTEGER

bigintThe big integer data type allows for a whole number between -9 quintillion to a value of positive 9 quintillion and will consume 8 bytes of data.

Be the first to comment on "Integer Data Types"

Leave a comment

Your email address will not be published.


*