Appendix CReserved Words and Keywords

Reserved words are part of the Firebird SQL language. They cannot be used as identifiers (e.g. as table or procedure names), except when enclosed in double quotes in Dialect 3. However, you should avoid this unless you have a compelling reason.

Keywords are also part of the language. They have a special meaning when used in the proper context, but they are not reserved for Firebird’s own and exclusive use. You can use them as identifiers without double-quoting.

C.1Reserved words

Full list of reserved words in Firebird 3.0:

ADD

ADMIN

ALL

ALTER

AND

ANY

AS

AT

AVG

BEGIN

BETWEEN

BIGINT

BIT_LENGTH

BLOB

BOOLEAN

BOTH

BY

CASE

CAST

CHAR

CHARACTER

CHARACTER_LENGTH

CHAR_LENGTH

CHECK

CLOSE

COLLATE

COLUMN

COMMIT

CONNECT

CONSTRAINT

CORR

COUNT

COVAR_POP

COVAR_SAMP

CREATE

CROSS

CURRENT

CURRENT_CONNECTION

CURRENT_DATE

CURRENT_ROLE

CURRENT_TIME

CURRENT_TIMESTAMP

CURRENT_TRANSACTION

CURRENT_USER

CURSOR

DATE

DAY

DEC

DECIMAL

DECLARE

DEFAULT

DELETE

DELETING

DETERMINISTIC

DISCONNECT

DISTINCT

DOUBLE

DROP

ELSE

END

ESCAPE

EXECUTE

EXISTS

EXTERNAL

EXTRACT

FALSE

FETCH

FILTER

FLOAT

FOR

FOREIGN

FROM

FULL

FUNCTION

GDSCODE

GLOBAL

GRANT

GROUP

HAVING

HOUR

IN

INDEX

INNER

INSENSITIVE

INSERT

INSERTING

INT

INTEGER

INTO

IS

JOIN

LEADING

LEFT

LIKE

LONG

LOWER

MAX

MERGE

MIN

MINUTE

MONTH

NATIONAL

NATURAL

NCHAR

NO

NOT

NULL

NUMERIC

OCTET_LENGTH

OF

OFFSET

ON

ONLY

OPEN

OR

ORDER

OUTER

OVER

PARAMETER

PLAN

POSITION

POST_EVENT

PRECISION

PRIMARY

PROCEDURE

RDB$DB_KEY

RDB$RECORD_VERSION

REAL

RECORD_VERSION

RECREATE

RECURSIVE

REFERENCES

REGR_AVGX

REGR_AVGY

REGR_COUNT

REGR_INTERCEPT

REGR_R2

REGR_SLOPE

REGR_SXX

REGR_SXY

REGR_SYY

RELEASE

RETURN

RETURNING_VALUES

RETURNS

REVOKE

RIGHT

ROLLBACK

ROW

ROWS

ROW_COUNT

SAVEPOINT

SCROLL

SECOND

SELECT

SENSITIVE

SET

SIMILAR

SMALLINT

SOME

SQLCODE

SQLSTATE

START

STDDEV_POP

STDDEV_SAMP

SUM

TABLE

THEN

TIME

TIMESTAMP

TO

TRAILING

TRIGGER

TRIM

TRUE

UNION

UNIQUE

UNKNOWN

UPDATE

UPDATING

UPPER

USER

USING

VALUE

VALUES

VARCHAR

VARIABLE

VARYING

VAR_POP

VAR_SAMP

VIEW

WHEN

WHERE

WHILE

WITH

YEAR