SQL Data Types

Here’s a list of all the formal data types that ISO/IEC standard SQL recognizes. In addition to these, you may define additional data types that are derived from these.

Exact Numerics:

• INTEGER

• SMALLINT

• BIGINT

• NUMERIC

• DECIMAL

Approximate Numerics:

• REAL

• DOUBLE PRECISION

• FLOAT

Binary Strings:

• BINARY

• BINARY VARYING

• BINARY LARGE OBJECT

Boolean:

• BOOLEAN

Character Strings:

• CHARACTER

• CHARACTER VARYING (VARCHAR)

• CHARACTER LARGE OBJECT

• NATIONAL CHARACTER

• NATIONAL CHARACTER VARYING

• NATIONAL CHARACTER LARGE OBJECT

Datetimes:

• DATE

• TIME WITHOUT TIMEZONE

• TIMESTAMP WITHOUT TIMEZONE

• TIME WITH TIMEZONE

• TIMESTAMP WITH TIMEZONE

Intervals:

• INTERVAL DAY

• INTERVAL YEAR

Collection Types:

• ARRAY

• MULTISET

Other Types:

• ROW

• XML