next up previous
Next: Schema definition in SQL Up: Data-Definition Language Previous: Data-Definition Language

Domain Types in SQL

  1. The SQL-92 standard supports a variety of built-in domain types:

  2. SQL-92 allows arithmetic and comparison operations on various numeric domains, including, interval and cast (type coercion) such as transforming between smallint and int. It considers strings with different length are compatible types as well.
  3. SQL-92 allows create domain statement, e.g.,

     create domain person-name char(20)

Osmar Zaiane
Fri May 22 19:39:12 PDT 1998