You are here: Reference Information > SQL Reference Information > SQL Keywords

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

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

REGEXP

reserved non-reserved non-reserved

RESTART

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

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

Reserved Built-in Function Names

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