Appendix B: Reserved words and keywords full lists

<< Appendix A: Notes | FB 2.5 Language Reference | Appendix C: Document History >>

Appendix B: Reserved words and keywords full lists

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
 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
 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
 UPPER
 USER
 USING
 VALUE
 VALUES
 VARCHAR
 VARIABLE
 VARYING
 VIEW
 WHEN
 WHERE
 WHILE
 WITH
 YEAR

Keywords

The following terms have a special meaning in Firebird 2.5 DSQL. Some of them are also reserved words, others aren't.

 !<
 ^<
 ^=
 ^>
 ,
 :=
 !=
 !>
 (
 )
 <
 <=
 <>
 =
 >
 >=
 ||
 ~<
 ~=
 ~> 
 ABS
 ACCENT
 ACOS
 ACTION
 ACTIVE
 ADD
 ADMIN
 AFTER
 ALL
 ALTER
 ALWAYS
 AND
 ANY
 AS
 ASC
 ASCENDING
 ASCII_CHAR
 ASCII_VAL
 ASIN
 AT
 ATAN
 ATAN2
 AUTO
 AUTONOMOUS
 AVG
 BACKUP
 BEFORE
 BEGIN
 BETWEEN
 BIGINT
 BIN_AND
 BIN_NOT
 BIN_OR
 BIN_SHL
 BIN_SHR
 BIN_XOR
 BIT_LENGTH
 BLOB
 BLOCK
 BOTH
 BREAK
 BY
 CALLER
 CASCADE
 CASE
 CAST
 CEIL
 CEILING
 CHAR
 CHAR_LENGTH
 CHAR_TO_UUID
 CHARACTER
 CHARACTER_LENGTH
 CHECK
 CLOSE
 COALESCE
 COLLATE
 COLLATION
 COLUMN
 COMMENT
 COMMIT
 COMMITTED
 COMMON
 COMPUTED
 CONDITIONAL
 CONNECT
 CONSTRAINT
 CONTAINING
 COS
 COSH
 COT
 COUNT
 CREATE
 CROSS
 CSTRING
 CURRENT
 CURRENT_CONNECTION
 CURRENT_DATE
 CURRENT_ROLE
 CURRENT_TIME
 CURRENT_TIMESTAMP
 CURRENT_TRANSACTION
 CURRENT_USER
 CURSOR
 DATA
 DATABASE
 DATE
 DATEADD
 DATEDIFF
 DAY
 DEC
 DECIMAL
 DECLARE
 DECODE
 DEFAULT
 DELETE
 DELETING
 DESC
 DESCENDING
 DESCRIPTOR
 DIFFERENCE
 DISCONNECT
 DISTINCT
 DO
 DOMAIN
 DOUBLE
 DROP
 ELSE
 END
 ENTRY_POINT
 ESCAPE
 EXCEPTION
 EXECUTE
 EXISTS
 EXIT
 EXP
 EXTERNAL
 EXTRACT
 FETCH
 FILE
 FILTER
 FIRST
 FIRSTNAME
 FLOAT
 FLOOR
 FOR
 FOREIGN
 FREE_IT
 FROM
 FULL
 FUNCTION 
 GDSCODE
 GEN_ID
 GEN_UUID
 GENERATED
 GENERATOR
 GLOBAL
 GRANT
 GRANTED
 GROUP
 HASH
 HAVING
 HOUR
 IF
 IGNORE
 IIF
 IN
 INACTIVE
 INDEX
 INNER
 INPUT_TYPE
 INSENSITIVE 
 INSERT
 INSERTING
 INT
 INTEGER
 INTO
 IS
 ISOLATION
 JOIN
 KEY
 LAST
 LASTNAME
 LEADING
 LEAVE
 LEFT
 LENGTH
 LEVEL
 LIKE
 LIMBO
 LIST
 LN
 LOCK
 LOG
 LOG10
 LONG
 LOWER
 LPAD 
 MANUAL
 MAPPING
 MATCHED
 MATCHING
 MAX
 MAXIMUM_SEGMENT
 MAXVALUE
 MERGE
 MIDDLENAME
 MILLISECOND
 MIN
 MINUTE
 MINVALUE
 MOD
 MODULE_NAME
 MONTH
 NAMES
 NATIONAL
 NATURAL
 NCHAR
 NEXT
 NO
 NOT
 NULL
 NULLIF
 NULLS
 NUMERIC
 OCTET_LENGTH
 OF
 ON
 ONLY
 OPEN
 OPTION
 OR
 ORDER
 OS_NAME
 OUTER
 OUTPUT_TYPE
 OVERFLOW
 OVERLAY
 PAD
 PAGE
 PAGE_SIZE
 PAGES
 PARAMETER
 PASSWORD
 PI
 PLACING
 PLAN
 POSITION
 POST_EVENT
 POWER
 PRECISION
 PRESERVE
 PRIMARY
 PRIVILEGES
 PROCEDURE
 PROTECTED
 RAND
 RDB$DB_KEY
 READ
 REAL
 RECORD_VERSION
 RECREATE
 RECURSIVE
 REFERENCES
 RELEASE
 REPLACE
 REQUESTS
 RESERV
 RESERVING
 RESTART
 RESTRICT
 RETAIN
 RETURNING
 RETURNING_VALUES
 RETURNS
 REVERSE
 REVOKE
 RIGHT
 ROLE
 ROLLBACK
 ROUND
 ROW_COUNT
 ROWS
 RPAD
 SAVEPOINT
 SCALAR_ARRAY
 SCHEMA
 SECOND
 SEGMENT
 SELECT
 SENSITIVE
 SEQUENCE
 SET
 SHADOW
 SHARED
 SIGN
 SIMILAR
 SIN
 SINGULAR
 SINH
 SIZE
 SKIP
 SMALLINT
 SNAPSHOT
 SOME
 SORT
 SOURCE
 SPACE
 SQLCODE
 SQLSTATE (2.5.1)
 SQRT
 STABILITY
 START
 STARTING
 STARTS
 STATEMENT
 STATISTICS
 SUB_TYPE
 SUBSTRING
 SUM
 SUSPEND
 TABLE
 TAN
 TANH
 TEMPORARY
 THEN
 TIME
 TIMEOUT 
 TIMESTAMP
 TO
 TRAILING
 TRANSACTION
 TRIGGER
 TRIM
 TRUNC
 TWO_PHASE
 TYPE
 UNCOMMITTED
 UNDO
 UNION
 UNIQUE
 UPDATE
 UPDATING
 UPPER
 USER
 USING
 UUID_TO_CHAR
 VALUE
 VALUES
 VARCHAR
 VARIABLE
 VARYING
 VIEW
 WAIT
 WEEK
 WEEKDAY
 WHEN
 WHERE
 WHILE
 WITH
 WORK
 WRITE
 YEAR
 YEARDAY

back to top of page
<< Appendix A: Notes | FB 2.5 Language Reference | Appendix C: Document History >>