Firebird Documentation IndexFirebird 1.5.6 Release NotesSQL Language Enhancements → New Reserved Words
Firebird Home Firebird Home Prev: Stored Procedure and Trigger Language (PSQL)Firebird Documentation IndexUp: SQL Language EnhancementsNext: Miscellaneous Enhancements

New Reserved Words

The following new Firebird keywords should be added to the list of reserved words published for InterBase 6.0.1.

      BIGINT (1.5)     CASE (1.5)                 CURRENT_CONNECTION (1.5)
      CURRENT_ROLE     CURRENT_TRANSACTION (1.5)  CURRENT_USER
      RECREATE         ROW_COUNT (1.5)            RELEASE
      SAVEPOINT
    

The following keywords are reserved for future planned use:

      ABS              BOOLEAN                    BOTH
      CHAR_LENGTH      CHARACTER_LENGTH           FALSE
      LEADING          OCTET_LENGTH               TRIM
      TRAILING         TRUE                       UNKNOWN
    

The following keywords were reserved words in Firebird 1.0 and are no longer reserved in Firebird 1.5:

      BREAK            DESCRIPTOR                 FIRST
      IIF              SKIP                       SUBSTRING
    

The following non-reserved words are recognised in 1.5 as keywords when used in their respective structural contexts:

      COALESCE         DELETING                   INSERTING
      LAST             LEAVE                      LOCK
      NULLIF           NULLS                      STATEMENT
      UPDATING         USING
    

The following new InterBase 6.5 and 7 keywords (not reserved in Firebird) should also be treated as if they were reserved, for compatibility:

      BOOLEAN          FALSE                      GLOBAL
      PERCENT          PRESERVE                   ROWS
      TEMPORARY        TIES                       TRUE
    
Prev: Stored Procedure and Trigger Language (PSQL)Firebird Documentation IndexUp: SQL Language EnhancementsNext: Miscellaneous Enhancements
Firebird Documentation IndexFirebird 1.5.6 Release NotesSQL Language Enhancements → New Reserved Words