Reserved words and changes
<< Changes to the Firebird API and ODS | Firebird 2.5.3 Release Notes | Configuration parameter additions and changes >>
Reserved words and changes
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 * |
back to top of page
<< Changes to the Firebird API and ODS | Firebird 2.5.3 Release Notes | Configuration parameter additions and changes >>