Skip to content

smallint (TP010)#

Automatic fix is available.

What it does#

Checks for usage of smallint.

Why not?#

Smallint can store values up to 32767 which can lead to integer overflow once the max value is reached. The fire drill when you run out of integers is not cheap.

When should you?#

Tables that store limited lookup options.

Use instead:#

bigint.