Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SMALLINT data type

The SMALLINT data type is used to store integers that require 2 bytes of storage.

[ UNSIGNED ] SMALLINT

The SMALLINT data type is an exact numeric data type; its accuracy is preserved after arithmetic operations. It requires 2 bytes of storage.

The range for signed SMALLINT values is -2¹⁵ to 2¹⁵ - 1, or -32768 to 32767.

The range for unsigned SMALLINT values is 0 to 2¹⁶ - 1, or 0 to 65535.

• BIGINT data type
• BIT data type
• INTEGER data type
• TINYINT data type
• Numeric functions
• Aggregate functions

• SQL/2003    Compatible with SQL/2003. The UNSIGNED keyword is a vendor extension.