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