New Reserved Words and Changes

Table of Contents

Newly Reserved Words Changed from Non-reserved to Reserved Keywords Added as Non-reserved Keywords No Longer Reserved No Longer Reserved as Keywords The following keywords have been added, or have changed status, since Firebird 1.5. Those marked with an asterisk (*) are not present in the SQL standard.

Newly Reserved Words

         BIT_LENGTH
         BOTH
         CHAR_LENGTH
         CHARACTER_LENGTH
         CLOSE
         CROSS
         FETCH
         LEADING
         LOWER
         OCTET_LENGTH
         OPEN
         ROWS
         TRAILING
         TRIM

Changed from Non-reserved to Reserved

         USING

Keywords Added as Non-reserved

         BACKUP *
         BLOCK *
         COLLATION
         COMMENT *
         DIFFERENCE *
         IIF *
         NEXT
         SCALAR_ARRAY *
         SEQUENCE
         RESTART
         RETURNING *

Keywords No Longer Reserved

         ACTION
         RESTRICT
         WEEKDAY *
         CASCADE
         ROLE
         YEARDAY *
         FREE_IT *
         TYPE

No Longer Reserved as Keywords

         BASENAME *
         GROUP_COMMIT_WAIT *
         NUM_LOG_BUFS *
         CACHE *
         LOGFILE *
         RAW_PARTITIONS *
         CHECK_POINT_LEN *
         LOG_BUF_SIZE *