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

REPLACE

reserved

non-reserved

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