SMALLINT - Small integer

You use the data type SMALLINT for columns that can store small integers (see section "Numeric values").

---

[{[ dimension ] | ( dimension )}] SMALLINT

---

dimension

Unsigned integer between 1 and 255. The column is a multiple column;
dimension indicates the number of column elements.

Any square brackets shown here in italics are special characters, and must be specified in the statement.

dimension omitted:
The column is an atomic column.

Range of values for SMALLINT columns

The range of values for a SMALLINT column is -2¹⁵ to 2¹⁵-1.

Example

You define a SMALLINT columns quantity as follows:

quantity SMALLINT