New reserved words and changes

<< Procedural SQL (PSQL) | Firebird 2.1.6 Release Notes | Indexing & optimizations >>

New reserved words and changes

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


Changed from non-reserved to reserved


Keywords added as non-reserved


Keywords no longer reserved

  • ACTION (v.2.0)
  • CASCADE (v.2.0)
  • FREE_IT * (v.2.0)
  • RESTRICT (v.2.0)
  • ROLE (v.2.0)
  • TYPE (v.2.0)
  • WEEKDAY * (v.2.0)
  • YEARDAY * (v.2.0)


No longer reserved as keywords

  • BASENAME * (v.2.0)
  • GROUP_COMMIT_WAIT * (v.2.0)
  • NUM_LOG_BUFS * (v.2.0)
  • CACHE * (v.2.0)
  • LOGFILE * (v.2.0)
  • RAW_PARTITIONS * (v.2.0)
  • CHECK_POINT_LEN * (v.2.0)
  • LOG_BUF_SIZE * (v.2.0)

back to top of page
<< Procedural SQL (PSQL) | Firebird 2.1.6 Release Notes | Indexing & optimizations >>