SQL Data Types

Part of the 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

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
SQL For Dummies Cheat Sheet

Advertisement

Inside Dummies.com