<< Introduction | FB 2.1 Language Reference | Miscellaneous language elements >>

Reserved words and keywords

Reserved words are part of the Firebird SQL language. They cannot be used as identifiers (e.g. 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.

Added since InterBase 6

Newly reserved words

The following reserved words have been added to Firebird:

 BIGINT
 BIT_LENGTH
 BOTH
 CASE
 CHAR_LENGTH
 CHARACTER_LENGTH
 CLOSE
 CONNECT
 CROSS
 CURRENT_CONNECTION
 CURRENT_ROLE
 CURRENT_TRANSACTION
 CURRENT_USER
 DISCONNECT
 FETCH
 GLOBAL
 INSENSITIVE
 LEADING
 LOWER
 OCTET_LENGTH
 OPEN
 RECREATE
 RECURSIVE
 RELEASE
 ROW_COUNT
 ROWS
 SAVEPOINT
 SENSITIVE
 START
 TRAILING
 TRIM
 USING

New keywords

The following words have been added to Firebird as non-reserved keywords:

 ABS
 ACCENT
 ACOS
 ALWAYS
 ASCII_CHAR
 ASCII_VAL
 ASIN
 ATAN
 ATAN2
 BACKUP
 BIN_AND
 BIN_OR
 BIN_SHL
 BIN_SHR
 BIN_XOR
 BLOCK
 CEIL
 CEILING
 COALESCE
 COLLATION
 COMMENT
 COS
 COSH
 COT
 DATEADD
 DATEDIFF
 DECODE
 DELETING
 DIFFERENCE
 EXP
 FLOOR
 GEN_UUID
 GENERATED
 HASH
 IIF
 INSERTING
 LAST
 LEAVE
 LIST
 LN
 LOCK
 LOG
 LOG10
 LPAD
 MATCHED
 MATCHING
 MAXVALUE
 MILLISECOND
 MINVALUE
 MOD
 NEXT
 NULLIF
 NULLS
 OVERLAY
 PAD
 PI
 PLACING
 POWER
 PRESERVE
 RAND
 REPLACE
 RESTART
 RETURNING
 REVERSE
 ROUND
 RPAD
 SCALAR_ARRAY
 SEQUENCE
 SIGN
 SIN
 SINH
 SPACE
 SQRT
 STATEMENT
 TAN
 TANH
 TEMPORARY
 TRUNC
 WEEK
 UPDATING

back to top of page

Dropped since InterBase 6

No longer reserved

The following words are no longer reserved in Firebird 2.1, but are still recognized as keywords:

 ACTION
 CASCADE
 FREE_IT
 RESTRICT
 ROLE
 TYPE
 WEEKDAY
 YEARDAY

No longer keywords

The following are no longer keywords in Firebird 2.1:

 BASENAME
 CACHE
 CHECK_POINT_LEN
 GROUP_COMMIT_WAIT
 LOG_BUF_SIZE
 LOGFILE
 NUM_LOG_BUFS
 RAW_PARTITIONS

Possibly reserved in future versions

The following words are not reserved in Firebird 2.1, but should be avoided as identifiers because they will likely be reserved in future versions:

 BOOLEAN
 FALSE
 TRUE
 UNKNOWN

back to top of page
<< Introduction | FB 2.1 Language Reference | Miscellaneous language elements >>