| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112 |
- ----------------------------------------------------
- SQL keywords introduced in different server versions
- ----------------------------------------------------
- An asterisk (*) mark shows that a keyword doesn't exist in the SQL specification
- and hence should be considered a non-standard language extention.
- Firebird 1.0:
- Added as reserved words:
- CURRENT_USER
- CURRENT_ROLE
- BREAK *
- DESCRIPTOR
- FIRST
- RECREATE *
- SKIP *
- SUBSTRING
- Firebird 1.5:
- Added as reserved words:
- CURRENT_CONNECTION *
- CURRENT_TRANSACTION *
- BIGINT
- CASE
- RELEASE
- ROW_COUNT
- SAVEPOINT
- Added as non-reserved words:
- COALESCE
- DELETING *
- INSERTING *
- LAST
- LEAVE
- LOCK *
- NULLIF
- NULLS
- STATEMENT
- UPDATING *
- USING
- Moved from reserved words to non-reserved:
- BREAK *
- DESCRIPTOR
- FIRST
- SKIP *
- SUBSTRING
- Firebird 2.0:
- Added as reserved words:
- BIT_LENGTH
- BOTH
- CHAR_LENGTH
- CHARACTER_LENGTH
- CLOSE
- CROSS
- FETCH
- LEADING
- LOWER
- OCTET_LENGTH
- OPEN
- ROWS
- TRAILING
- TRIM
- Moved from non-reserved words to reserved:
- USING
- Added as non-reserved words:
- BACKUP *
- BLOCK *
- COLLATION
- COMMENT *
- DIFFERENCE *
- IIF *
- NEXT
- SCALAR_ARRAY *
- SEQUENCE
- RESTART
- RETURNING *
- Moved from reserved words to non-reserved:
- ACTION
- CASCADE
- FREE_IT *
- RESTRICT
- ROLE
- TYPE
- WEEKDAY *
- YEARDAY *
- Removed reserved words:
- BASENAME *
- CACHE *
- CHECK_POINT_LEN *
- GROUP_COMMIT_WAIT *
- LOGFILE *
- LOG_BUF_SIZE *
- NUM_LOG_BUFS *
- RAW_PARTITIONS *
|