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