<< Data Manipulation Language (DML) | Firebird 2.0.7 Release Notes | Stored Procedure Language (PSQL) >>

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

• 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 *

back to top of page
<< Data Manipulation Language (DML) | Firebird 2.0.7 Release Notes | Stored Procedure Language (PSQL) >>