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`.
|
SQL Keyword |
NuoDB |
SQL 2003 |
SQL 1999 |
|---|---|---|---|
|
ALL |
reserved | reserved | 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 |
|
CONTINUE |
reserved | reserved | 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 |
|
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 |
|
FOR_UPDATE |
reserved | non-reserved | non-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 |
|
LOGICAL_AND |
reserved | non-reserved | non-reserved |
|
LOGICAL_NOT |
reserved | non-reserved | non-reserved |
|
LOGICAL_OR |
reserved | non-reserved | non-reserved |
|
MAX |
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_BETWEEN |
reserved | non-reserved | non-reserved |
|
NOT_CONTAINING |
reserved | non-reserved | non-reserved |
|
NOT_IN |
reserved | non-reserved | non-reserved |
|
NOT_LIKE |
reserved | non-reserved | non-reserved |
|
NOT_STARTING |
reserved | non-reserved | non-reserved |
|
NTEXT |
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 |
|
ORDER |
reserved | reserved | reserved |
|
OUT |
reserved | reserved | reserved |
|
PRIMARY |
reserved | reserved | reserved |
|
REAL |
reserved | reserved | reserved |
|
RECORD_BATCHING |
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 |
|
SMALLDATETIME |
reserved | non-reserved | non-reserved |
|
SMALLINT |
reserved | reserved | reserved |
|
STARTING |
reserved | non-reserved | non-reserved |
|
STRING_TYPE |
reserved | non-reserved | non-reserved |
|
THEN |
reserved | reserved | reserved |
|
THROW |
reserved | non-reserved | non-reserved |
|
TINYBLOB |
reserved | non-reserved | non-reserved |
|
TINYINT |
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 |
|
Function Name |
NuoDB 2.0 |
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 |