ASA SQL Reference
  SQL Data Types
    Numeric data types

SMALLINT data type [Numeric]

Function 

Integer requiring 2 bytes of storage.

Syntax 

[ UNSIGNED ] SMALLINT

Usage 

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.

Standards and compatibility 

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

• Sybase    The signed data type is compatible with Adaptive Server Enterprise. Adaptive Server Enterprise does not support the UNSIGNED data type.

See also 

INT or INTEGER data type [Numeric]

TINYINT data type [Numeric]

BIGINT data type [Numeric]