SQL Keywords
NuoDB reserves the SQL keywords and built-in function names listed in the following tables.
The default escape character in NuoDB is a backslash \. To use a keyword or a built-in function name as an identifier, enclose the keyword in back-ticks, for example: GROUP.
Reserved SQL Keywords
| SQL Keyword | NuoDB | SQL 2003 | SQL 1999 |
|---|---|---|---|
ALL |
reserved |
reserved |
reserved |
AND |
reserved |
non-reserved |
non-reserved |
AS |
reserved |
reserved |
reserved |
BETWEEN |
reserved |
reserved |
reserved |
BITS |
reserved |
non-reserved |
non-reserved |
BOTH |
reserved |
reserved |
reserved |
BREAK |
reserved |
non-reserved |
non-reserved |
BY |
reserved |
reserved |
reserved |
CALL |
reserved |
reserved |
reserved |
CASCADE |
reserved |
non-reserved |
reserved |
CASE |
reserved |
reserved |
reserved |
CATCH |
reserved |
non-reserved |
non-reserved |
COLLATE |
reserved |
reserved |
reserved |
COLUMN |
reserved |
reserved |
reserved |
CONSTRAINT |
reserved |
reserved |
reserved |
CONTAINING |
reserved |
non-reserved |
non-reserved |
CREATE |
reserved |
reserved |
reserved |
CURRENT |
reserved |
reserved |
reserved |
CURRENT_DATE |
reserved |
reserved |
reserved |
CURRENT_TIME |
reserved |
reserved |
reserved |
CURRENT_TIMESTAMP |
reserved |
reserved |
reserved |
DEFAULT |
reserved |
reserved |
reserved |
DELETE |
reserved |
reserved |
reserved |
DESCRIBE |
reserved |
reserved |
reserved |
DISTINCT |
reserved |
reserved |
reserved |
ELSE |
reserved |
reserved |
reserved |
ELSE_IF |
reserved |
reserved |
reserved |
END |
reserved |
reserved |
reserved |
END_FOR |
reserved |
non-reserved |
non-reserved |
END_FUNCTION |
reserved |
non-reserved |
non-reserved |
END_IF |
reserved |
non-reserved |
non-reserved |
END_PROCEDURE |
reserved |
non-reserved |
non-reserved |
END_TRIGGER |
reserved |
non-reserved |
non-reserved |
END_TRY |
reserved |
non-reserved |
non-reserved |
END_WHILE |
reserved |
non-reserved |
non-reserved |
ENUM |
reserved |
non-reserved |
non-reserved |
ESCAPE |
reserved |
reserved |
reserved |
EXECUTE |
reserved |
reserved |
reserved |
EXISTS |
reserved |
reserved |
reserved |
FALSE |
reserved |
reserved |
reserved |
FETCH |
reserved |
reserved |
reserved |
FOR |
reserved |
reserved |
reserved |
FOREIGN |
reserved |
reserved |
reserved |
FROM |
reserved |
reserved |
reserved |
FULL |
reserved |
reserved |
reserved |
GENERATED |
reserved |
non-reserved |
non-reserved |
GROUP |
reserved |
reserved |
reserved |
HAVING |
reserved |
reserved |
reserved |
IDENTITY |
reserved |
reserved |
reserved |
IF |
reserved |
reserved |
reserved |
IN |
reserved |
reserved |
reserved |
INNER |
reserved |
reserved |
reserved |
INOUT |
reserved |
reserved |
reserved |
INSERT |
reserved |
reserved |
reserved |
INTO |
reserved |
reserved |
reserved |
IS |
reserved |
reserved |
reserved |
JOIN |
reserved |
reserved |
reserved |
KEY |
reserved |
non-reserved |
reserved |
LEADING |
reserved |
reserved |
reserved |
LEFT |
reserved |
reserved |
reserved |
LIKE |
reserved |
reserved |
reserved |
LIMIT |
reserved |
non-reserved |
non-reserved |
NATIONAL |
reserved |
reserved |
reserved |
NATURAL |
reserved |
reserved |
reserved |
NCHAR |
reserved |
reserved |
reserved |
NCLOB |
reserved |
reserved |
reserved |
NEXT |
reserved |
non-reserved |
reserved |
NEXT_VALUE |
reserved |
non-reserved |
non-reserved |
NOT |
reserved |
non-reserved |
non-reserved |
NULL |
reserved |
reserved |
reserved |
NUMERIC |
reserved |
reserved |
reserved |
NVARCHAR |
reserved |
non-reserved |
non-reserved |
OCTETS |
reserved |
non-reserved |
non-reserved |
OFF |
reserved |
non-reserved |
non-reserved |
OFFSET |
reserved |
non-reserved |
non-reserved |
ON |
reserved |
reserved |
reserved |
ONLY |
reserved |
reserved |
reserved |
OR |
reserved |
non-reserved |
non-reserved |
ORDER |
reserved |
reserved |
reserved |
OUT |
reserved |
reserved |
reserved |
PRIMARY |
reserved |
reserved |
reserved |
REAL |
reserved |
reserved |
reserved |
RECORD_BATCHING |
reserved |
non-reserved |
non-reserved |
RECORD_NUMBER |
reserved |
non-reserved |
non-reserved |
REFERENCES |
reserved |
reserved |
reserved |
RESTRICT |
reserved |
non-reserved |
reserved |
RETURN |
reserved |
reserved |
reserved |
RIGHT |
reserved |
reserved |
reserved |
ROLLBACK |
reserved |
reserved |
reserved |
ROWS |
reserved |
reserved |
reserved |
SELECT |
reserved |
reserved |
reserved |
SET |
reserved |
reserved |
reserved |
SHOW |
reserved |
non-reserved |
non-reserved |
SMALLINT |
reserved |
reserved |
reserved |
STARTING |
reserved |
non-reserved |
non-reserved |
STRING |
reserved |
non-reserved |
non-reserved |
THEN |
reserved |
reserved |
reserved |
THROW |
reserved |
non-reserved |
non-reserved |
TO |
reserved |
reserved |
reserved |
TRAILING |
reserved |
reserved |
reserved |
TRUE |
reserved |
reserved |
reserved |
TRY |
reserved |
non-reserved |
non-reserved |
UNION |
reserved |
reserved |
reserved |
UNIQUE |
reserved |
reserved |
reserved |
UNKNOWN |
reserved |
reserved |
reserved |
UPDATE |
reserved |
reserved |
reserved |
USING |
reserved |
reserved |
reserved |
VAR |
reserved |
non-reserved |
non-reserved |
VER |
reserved |
non-reserved |
non-reserved |
WHEN |
reserved |
reserved |
reserved |
WHERE |
reserved |
reserved |
reserved |
WHILE |
reserved |
non-reserved |
non-reserved |
WITH |
reserved |
reserved |
reserved |
_RECORD_ID |
reserved |
non-reserved |
non-reserved |
_RECORD_PARTITIONID |
reserved |
non-reserved |
non-reserved |
_RECORD_SEQUENCE |
reserved |
non-reserved |
non-reserved |
_RECORD_TRANSACTION |
reserved |
non-reserved |
non-reserved |
Reserved Built-in Function Names
| Function Name | NuoDB | SQL 2003 | SQL 1999 |
|---|---|---|---|
ABS |
reserved |
non-reserved |
non-reserved |
ACOS |
reserved |
non-reserved |
non-reserved |
ASIN |
reserved |
non-reserved |
non-reserved |
ATAN2 |
reserved |
non-reserved |
non-reserved |
ATAN |
reserved |
non-reserved |
non-reserved |
BIT_LENGTH |
reserved |
non-reserved |
non-reserved |
CAST |
reserved |
reserved |
reserved |
CEILING |
reserved |
non-reserved |
non-reserved |
CHARACTER_LENGTH |
reserved |
non-reserved |
non-reserved |
COALESCE |
reserved |
non-reserved |
non-reserved |
CONCAT |
reserved |
non-reserved |
non-reserved |
CONVERT_TZ |
reserved |
non-reserved |
non-reserved |
COS |
reserved |
non-reserved |
non-reserved |
COT |
reserved |
non-reserved |
non-reserved |
CURRENT_USER |
reserved |
reserved |
reserved |
DATE |
reserved |
reserved |
reserved |
DATE_ADD |
reserved |
non-reserved |
non-reserved |
DATE_SUB |
reserved |
non-reserved |
non-reserved |
DAYOFWEEK |
reserved |
non-reserved |
non-reserved |
DAY |
reserved |
reserved |
reserved |
DEGREES |
reserved |
non-reserved |
non-reserved |
EXTRACT |
reserved |
non-reserved |
non-reserved |
FLOOR |
reserved |
non-reserved |
non-reserved |
GREATEST |
reserved |
non-reserved |
non-reserved |
HOUR |
reserved |
reserved |
reserved |
IFNULL |
reserved |
non-reserved |
non-reserved |
LEAST |
reserved |
non-reserved |
non-reserved |
LOCATE |
reserved |
non-reserved |
non-reserved |
LOWER |
reserved |
non-reserved |
non-reserved |
LTRIM |
reserved |
non-reserved |
non-reserved |
MINUTE |
reserved |
reserved |
reserved |
MOD |
reserved |
non-reserved |
non-reserved |
MONTH |
reserved |
reserved |
reserved |
MSLEEP |
reserved |
non-reserved |
non-reserved |
NOW |
reserved |
non-reserved |
non-reserved |
NULLIF |
reserved |
non-reserved |
non-reserved |
OCTET_LENGTH |
reserved |
non-reserved |
non-reserved |
OPTIONAL_FIELD |
reserved |
non-reserved |
non-reserved |
PI |
reserved |
non-reserved |
non-reserved |
POSITION |
reserved |
non-reserved |
non-reserved |
POWER |
reserved |
non-reserved |
non-reserved |
RADIANS |
reserved |
non-reserved |
non-reserved |
RAND |
reserved |
non-reserved |
non-reserved |
REPLACE |
reserved |
non-reserved |
non-reserved |
ROUND |
reserved |
non-reserved |
non-reserved |
RTRIM |
reserved |
non-reserved |
non-reserved |
SECOND |
reserved |
reserved |
reserved |
SIN |
reserved |
non-reserved |
non-reserved |
SQRT |
reserved |
non-reserved |
non-reserved |
SUBSTRING_INDEX |
reserved |
non-reserved |
non-reserved |
SUBSTR |
reserved |
non-reserved |
non-reserved |
TAN |
reserved |
non-reserved |
non-reserved |
TRIM |
reserved |
non-reserved |
non-reserved |
UPPER |
reserved |
non-reserved |
non-reserved |
USER |
reserved |
reserved |
reserved |
YEAR |
reserved |
reserved |
reserved |