Appendix C. Reserved 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.1. Reserved words

Full list of reserved words in Firebird 2.5:

ADD

ADMIN

ALL

ALTER

AND

ANY

AS

AT

AVG

BEGIN

BETWEEN

BIGINT

BIT_LENGTH

BLOB

BOTH

BY

CASE

CAST

CHAR

CHAR_LENGTH

CHARACTER

CHARACTER_LENGTH

CHECK

CLOSE

COLLATE

COLUMN

COMMIT

CONNECT

CONSTRAINT

COUNT

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

DISCONNECT

DISTINCT

DOUBLE

DROP

ELSE

END

ESCAPE

EXECUTE

EXISTS

EXTERNAL

EXTRACT

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

MAXIMUM_SEGMENT

MERGE

MIN

MINUTE

MONTH

NATIONAL

NATURAL

NCHAR

NO

NOT

NULL

NUMERIC

OCTET_LENGTH

OF

ON

ONLY

OPEN

OR

ORDER

OUTER

PARAMETER

PLAN

POSITION

POST_EVENT

PRECISION

PRIMARY

PROCEDURE

RDB$DB_KEY

REAL

RECORD_VERSION

RECREATE

RECURSIVE

REFERENCES

RELEASE

RETURNING_VALUES

RETURNS

REVOKE

RIGHT

ROLLBACK

ROW_COUNT

ROWS

SAVEPOINT

SECOND

SELECT

SENSITIVE

SET

SIMILAR

SMALLINT

SOME

SQLCODE

SQLSTATE (2.5.1)

START

SUM

TABLE

THEN

TIME

TIMESTAMP

TO

TRAILING

TRIGGER

TRIM

UNION

UNIQUE

UPDATE

UPDATING

UPPER

USER

USING

VALUE

VALUES

VARCHAR

VARIABLE

VARYING

VIEW

WHEN

WHERE

WHILE

WITH

YEAR