INTEGER - Integers

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

---

[{[ dimension ] | ( dimension )}] INT[EGER]

---

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 INTEGER columns

The range of values for an INTEGER column is -2³¹ to 2³¹-1.

Example

The SERVICE table has three INTEGER columns: service_num INTEGER order_num INTEGER NOT NULL service_total INTEGER CHECK (service_total > 0)