8 Reserved Words

TimesTen reserves words for use in SQL statements.You cannot use reserved words as non-quoted identifiers.

To use one of these words as an identifier (such as a table name or column name), enclose the reserved word in quotes.

The reserved words are:

  • AGING

  • ALL

  • ANY

  • AS

  • BETWEEN

  • BINARY_DOUBLE_INFINITY

  • BINARY_DOUBLE_NAN

  • BINARY_FLOAT_INFINITY

  • BINARY_FLOAT_NAN

  • CASE

  • CHAR

  • COLUMN

  • COLUMNAR

  • CONNECTION

  • CONSTRAINT

  • CROSS

  • CURRENT_SCHEMA

  • CURRENT_USER

  • CURSOR

  • DATASTORE_OWNER

  • DATE

  • DECIMAL

  • DEFAULT

  • DESTROY

  • DISTINCT

  • DISTRIBUTE

  • FIRST

  • FLOAT

  • FOR

  • FOREIGN

  • FROM

  • GROUP

  • HAVING

  • INNER

  • INTEGER

  • INTERSECT

  • INTERVAL

  • INTO

  • IS

  • JOIN

  • LEFT

  • LIKE

  • LONG

  • MINUS

  • NULL

  • ON

  • ORA_SYSDATE

  • ORDER

  • PRIMARY

  • PROPAGATE

  • PUBLIC

  • READONLY

  • RIGHT

  • ROWNUM

  • ROWS

  • SELECT

  • SELF

  • SESSION_USER

  • SET

  • SMALLINT

  • SOME

  • SYSDATE

  • SYSTEM_USER

  • TO

  • TT_SYSDATE

  • UID

  • UNION

  • UNIQUE

  • UPDATE

  • USER

  • USING

  • VARCHAR

  • WHEN

  • WHERE

  • WITH