Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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 -215 to 215 - 1, or -32768 to 32767.
The range for unsigned SMALLINT values is 0 to 216 - 1, or 0 to 65535.
SQL/2003 Compatible with SQL/2003. The UNSIGNED keyword is a vendor extension.