Reserved words and keywords
<< 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
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 >>
