Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateReserved words and keywords → Added since InterBase 6
Firebird Home Firebird Home Prev: Reserved words and keywordsFirebird Documentation IndexUp: Reserved words and keywordsNext: Dropped since InterBase 6

Added since InterBase 6

Table of Contents

Newly reserved words
New non-reserved keywords

Newly reserved words

The following reserved words have been added to Firebird:

BIGINT
BIT_LENGTH
BOTH
CASE
CLOSE
CONNECT
CROSS
CURRENT_CONNECTION
CURRENT_ROLE
CURRENT_TRANSACTION
CURRENT_USER
DISCONNECT
FETCH
GLOBAL
INSENSITIVE
LEADING
LOWER
OPEN
RECREATE
RECURSIVE
ROW_COUNT
ROWS
SAVEPOINT
SENSITIVE
SIMILAR
SQLSTATE (2.5.1)
START
TRAILING
TRIM

New non-reserved keywords

The following words have been added to Firebird as non-reserved keywords. More than half of them are names of internal functions added between 2.0 and 2.1.

ABS
ACCENT
ACOS
ALWAYS
ASCII_CHAR
ASCII_VAL
ASIN
ATAN
ATAN2
AUTONOMOUS
BACKUP
BIN_AND
BIN_OR
BIN_NOT
BIN_SHL
BIN_SHR
BIN_XOR
BLOCK
BREAK
CALLER
CEIL
CEILING
CHAR_TO_UUID
COALESCE
COLLATION
COMMENT
COMMON
COS
COSH
COT
DATA
DATEADD
DATEDIFF
DECODE
DELETING
DIFFERENCE
EXP
FIRST
FIRSTNAME
FLOOR
GEN_UUID
GENERATED
GRANTED
HASH
IIF
INSERTING
LAST
LASTNAME
LEAVE
LIST
LN
LOCK
LOG
LOG10
LPAD
MAPPING
MATCHED
MATCHING
MAXVALUE
MIDDLENAME
MILLISECOND
MINVALUE
MOD
NEXT
NULLIF
NULLS
OS_NAME
OVERLAY
PAD
PI
PLACING
POWER
PRESERVE
RAND
REPLACE
RESTART
RETURNING
REVERSE
ROUND
RPAD
SCALAR_ARRAY
SEQUENCE
SIGN
SIN
SINH
SKIP
SOURCE
SPACE
SQRT
SUBSTRING
TAN
TANH
TEMPORARY
TRUNC
TWO_PHASE
WEEK
UPDATING
UUID_TO_CHAR
Prev: Reserved words and keywordsFirebird Documentation IndexUp: Reserved words and keywordsNext: Dropped since InterBase 6
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateReserved words and keywords → Added since InterBase 6