Appendix C. Reserved Words and Keywords

Reserved words are part of the Firebird SQL language. They cannot be used as identifiers (e.g. as table or procedure names), except when enclosed in double quotes in Dialect 3. However, you should avoid this unless you have a compelling reason.

Keywords are also part of the language. They have a special meaning when used in the proper context, but they are not reserved for Firebird’s own and exclusive use. You can use them as identifiers without double-quoting.

C.1. Reserved words

Full list of reserved words in Firebird 3.0:

`ADD`	`ADMIN`	`ALL`
`ALTER`	`AND`	`ANY`
`AS`	`AT`	`AVG`
`BEGIN`	`BETWEEN`	`BIGINT`
`BIT_LENGTH`	`BLOB`	`BOOLEAN`
`BOTH`	`BY`	`CASE`
`CAST`	`CHAR`	`CHARACTER`
`CHARACTER_LENGTH`	`CHAR_LENGTH`	`CHECK`
`CLOSE`	`COLLATE`	`COLUMN`
`COMMIT`	`CONNECT`	`CONSTRAINT`
`CORR`	`COUNT`	`COVAR_POP`
`COVAR_SAMP`	`CREATE`	`CROSS`
`CURRENT`	`CURRENT_CONNECTION`	`CURRENT_DATE`
`CURRENT_ROLE`	`CURRENT_TIME`	`CURRENT_TIMESTAMP`
`CURRENT_TRANSACTION`	`CURRENT_USER`	`CURSOR`
`DATE`	`DAY`	`DEC`
`DECIMAL`	`DECLARE`	`DEFAULT`
`DELETE`	`DELETING`	`DETERMINISTIC`
`DISCONNECT`	`DISTINCT`	`DOUBLE`
`DROP`	`ELSE`	`END`
`ESCAPE`	`EXECUTE`	`EXISTS`
`EXTERNAL`	`EXTRACT`	`FALSE`
`FETCH`	`FILTER`	`FLOAT`
`FOR`	`FOREIGN`	`FROM`
`FULL`	`FUNCTION`	`GDSCODE`
`GLOBAL`	`GRANT`	`GROUP`
`HAVING`	`HOUR`	`IN`
`INDEX`	`INNER`	`INSENSITIVE`
`INSERT`	`INSERTING`	`INT`
`INTEGER`	`INTO`	`IS`
`JOIN`	`LEADING`	`LEFT`
`LIKE`	`LONG`	`LOWER`
`MAX`	`MERGE`	`MIN`
`MINUTE`	`MONTH`	`NATIONAL`
`NATURAL`	`NCHAR`	`NO`
`NOT`	`NULL`	`NUMERIC`
`OCTET_LENGTH`	`OF`	`OFFSET`
`ON`	`ONLY`	`OPEN`
`OR`	`ORDER`	`OUTER`
`OVER`	`PARAMETER`	`PLAN`
`POSITION`	`POST_EVENT`	`PRECISION`
`PRIMARY`	`PROCEDURE`	`RDB$DB_KEY`
`RDB$RECORD_VERSION`	`REAL`	`RECORD_VERSION`
`RECREATE`	`RECURSIVE`	`REFERENCES`
`REGR_AVGX`	`REGR_AVGY`	`REGR_COUNT`
`REGR_INTERCEPT`	`REGR_R2`	`REGR_SLOPE`
`REGR_SXX`	`REGR_SXY`	`REGR_SYY`
`RELEASE`	`RETURN`	`RETURNING_VALUES`
`RETURNS`	`REVOKE`	`RIGHT`
`ROLLBACK`	`ROW`	`ROWS`
`ROW_COUNT`	`SAVEPOINT`	`SCROLL`
`SECOND`	`SELECT`	`SENSITIVE`
`SET`	`SIMILAR`	`SMALLINT`
`SOME`	`SQLCODE`	`SQLSTATE`
`START`	`STDDEV_POP`	`STDDEV_SAMP`
`SUM`	`TABLE`	`THEN`
`TIME`	`TIMESTAMP`	`TO`
`TRAILING`	`TRIGGER`	`TRIM`
`TRUE`	`UNION`	`UNIQUE`
`UNKNOWN`	`UPDATE`	`UPDATING`
`UPPER`	`USER`	`USING`
`VALUE`	`VALUES`	`VARCHAR`
`VARIABLE`	`VARYING`	`VAR_POP`
`VAR_SAMP`	`VIEW`	`WHEN`
`WHERE`	`WHILE`	`WITH`
`YEAR`

Prev	Up	Next
B.2. SQLCODE and GDSCODE Error Codes and Descriptions	Home	C.2. Keywords