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 |
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 |
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 |
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 |
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 |