Reserved Words and Changes

Table of Contents

Clean-up of Reserved Words
Newly Reserved Words
Keywords Added as Non-reserved
Note

Asterisks (*) mark keywords that are reserved, or otherwise recognised by Firebird's grammar as keywords, but are not reserved words in the SQL standard.

Clean-up of Reserved Words

A. Peshkov

Tracker reference CORE-2638

The number of Firebird-specific reserved words has been reduced significantly, in order to mitigate the pain of keyword conflicts when converting other databases to Firebird. Where possible, words that are not reserved by the standard have been made non-reserved in Firebird's grammar.

A small list remains of words that are reserved in Firebird but not in the SQL standard. They are:

     ADD *       DB_KEY *    GDSCODE *      INDEX *
     LONG *      PLAN *      POST_EVENT *   RETURNING_VALUES *
     SQLCODE *   VARIABLE *  VIEW *

 
All other non-standard keywords previously reserved are now available for any reasonable purpose.

Newly Reserved Words

     SIMILAR               SQLSTATE
 
Keywords Added as Non-reserved

     AUTONOMOUS *          BIN_NOT *        CALLER *
     CHAR_TO_UUID *        COMMON *         DATA
     FIRSTNAME *           GRANTED          LASTNAME *
     MIDDLENAME *          MAPPING *        OS_NAME *
     SOURCE *              TWO_PHASE *      UUID_TO_CHAR *