Learn more with dummies

Enter your email to join our mailing list for FREE content right to your inbox. Easy!

By Allen G. Taylor

Part of SQL For Dummies Cheat Sheet

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