C.2. Keywords

The following terms have a special meaning in Firebird 4.0 DSQL (as of 4.0.1). Some of them are also reserved words, others are not.

`!<`	`^<`	`^=`
`^>`	`,`	`:=`
`!=`	`!>`	`(`
`)`	`<`	`⇐`
`<>`	`=`	`>`
`>=`	`\|\|`	`~<`
`~=`	`~>`	`ABS`
`ABSOLUTE`	`ACCENT`	`ACOS`
`ACOSH`	`ACTION`	`ACTIVE`
`ADD`	`ADMIN`	`AFTER`
`ALL`	`ALTER`	`ALWAYS`
`AND`	`ANY`	`AS`
`ASC`	`ASCENDING`	`ASCII_CHAR`
`ASCII_VAL`	`ASIN`	`ASINH`
`AT`	`ATAN`	`ATAN2`
`ATANH`	`AUTO`	`AUTONOMOUS`
`AVG`	`BACKUP`	`BASE64_DECODE`
`BASE64_ENCODE`	`BEFORE`	`BEGIN`
`BETWEEN`	`BIGINT`	`BINARY`
`BIND`	`BIN_AND`	`BIN_NOT`
`BIN_OR`	`BIN_SHL`	`BIN_SHR`
`BIN_XOR`	`BIT_LENGTH`	`BLOB`
`BLOCK`	`BODY`	`BOOLEAN`
`BOTH`	`BREAK`	`BY`
`CALLER`	`CASCADE`	`CASE`
`CAST`	`CEIL`	`CEILING`
`CHAR`	`CHARACTER`	`CHARACTER_LENGTH`
`CHAR_LENGTH`	`CHAR_TO_UUID`	`CHECK`
`CLEAR`	`CLOSE`	`COALESCE`
`COLLATE`	`COLLATION`	`COLUMN`
`COMMENT`	`COMMIT`	`COMMITTED`
`COMMON`	`COMPARE_DECFLOAT`	`COMPUTED`
`CONDITIONAL`	`CONNECT`	`CONNECTIONS`
`CONSISTENCY`	`CONSTRAINT`	`CONTAINING`
`CONTINUE`	`CORR`	`COS`
`COSH`	`COT`	`COUNT`
`COUNTER`	`COVAR_POP`	`COVAR_SAMP`
`CREATE`	`CROSS`	`CRYPT_HASH`
`CSTRING`	`CTR_BIG_ENDIAN`	`CTR_LENGTH`
`CTR_LITTLE_ENDIAN`	`CUME_DIST`	`CURRENT`
`CURRENT_CONNECTION`	`CURRENT_DATE`	`CURRENT_ROLE`
`CURRENT_TIME`	`CURRENT_TIMESTAMP`	`CURRENT_TRANSACTION`
`CURRENT_USER`	`CURSOR`	`DATA`
`DATABASE`	`DATE`	`DATEADD`
`DATEDIFF`	`DAY`	`DDL`
`DEBUG`	`DEC`	`DECFLOAT`
`DECIMAL`	`DECLARE`	`DECODE`
`DECRYPT`	`DEFAULT`	`DEFINER`
`DELETE`	`DELETING`	`DENSE_RANK`
`DESC`	`DESCENDING`	`DESCRIPTOR`
`DETERMINISTIC`	`DIFFERENCE`	`DISABLE`
`DISCONNECT`	`DISTINCT`	`DO`
`DOMAIN`	`DOUBLE`	`DROP`
`ELSE`	`ENABLE`	`ENCRYPT`
`END`	`ENGINE`	`ENTRY_POINT`
`ESCAPE`	`EXCEPTION`	`EXCESS`
`EXCLUDE`	`EXECUTE`	`EXISTS`
`EXIT`	`EXP`	`EXTENDED`
`EXTERNAL`	`EXTRACT`	`FALSE`
`FETCH`	`FILE`	`FILTER`
`FIRST`	`FIRSTNAME`	`FIRST_DAY`
`FIRST_VALUE`	`FLOAT`	`FLOOR`
`FOLLOWING`	`FOR`	`FOREIGN`
`FREE_IT`	`FROM`	`FULL`
`FUNCTION`	`GDSCODE`	`GENERATED`
`GENERATOR`	`GEN_ID`	`GEN_UUID`
`GLOBAL`	`GRANT`	`GRANTED`
`GROUP`	`HASH`	`HAVING`
`HEX_DECODE`	`HEX_ENCODE`	`HOUR`
`IDENTITY`	`IDLE`	`IF`
`IGNORE`	`IIF`	`IN`
`INACTIVE`	`INCLUDE`	`INCREMENT`
`INDEX`	`INNER`	`INPUT_TYPE`
`INSENSITIVE`	`INSERT`	`INSERTING`
`INT`	`INT128`	`INTEGER`
`INTO`	`INVOKER`	`IS`
`ISOLATION`	`IV`	`JOIN`
`KEY`	`LAG`	`LAST`
`LASTNAME`	`LAST_DAY`	`LAST_VALUE`
`LATERAL`	`LEAD`	`LEADING`
`LEAVE`	`LEFT`	`LEGACY`
`LENGTH`	`LEVEL`	`LIFETIME`
`LIKE`	`LIMBO`	`LINGER`
`LIST`	`LN`	`LOCAL`
`LOCALTIME`	`LOCALTIMESTAMP`	`LOCK`
`LOG`	`LOG10`	`LONG`
`LOWER`	`LPAD`	`LPARAM`
`MAKE_DBKEY`	`MANUAL`	`MAPPING`
`MATCHED`	`MATCHING`	`MAX`
`MAXVALUE`	`MERGE`	`MESSAGE`
`MIDDLENAME`	`MILLISECOND`	`MIN`
`MINUTE`	`MINVALUE`	`MOD`
`MODE`	`MODULE_NAME`	`MONTH`
`NAME`	`NAMES`	`NATIONAL`
`NATIVE`	`NATURAL`	`NCHAR`
`NEXT`	`NO`	`NORMALIZE_DECFLOAT`
`NOT`	`NTH_VALUE`	`NTILE`
`NULL`	`NULLIF`	`NULLS`
`NUMBER`	`NUMERIC`	`OCTET_LENGTH`
`OF`	`OFFSET`	`OLDEST`
`ON`	`ONLY`	`OPEN`
`OPTION`	`OR`	`ORDER`
`OS_NAME`	`OTHERS`	`OUTER`
`OUTPUT_TYPE`	`OVER`	`OVERFLOW`
`OVERLAY`	`OVERRIDING`	`PACKAGE`
`PAD`	`PAGE`	`PAGES`
`PAGE_SIZE`	`PARAMETER`	`PARTITION`
`PASSWORD`	`PERCENT_RANK`	`PI`
`PKCS_1_5`	`PLACING`	`PLAN`
`PLUGIN`	`POOL`	`POSITION`
`POST_EVENT`	`POWER`	`PRECEDING`
`PRECISION`	`PRESERVE`	`PRIMARY`
`PRIOR`	`PRIVILEGE`	`PRIVILEGES`
`PROCEDURE`	`PROTECTED`	`PUBLICATION`
`QUANTIZE`	`RAND`	`RANGE`
`RANK`	`RDB$DB_KEY`	`RDB$ERROR`
`RDB$GET_CONTEXT`	`RDB$GET_TRANSACTION_CN`	`RDB$RECORD_VERSION`
`RDB$ROLE_IN_USE`	`RDB$SET_CONTEXT`	`RDB$SYSTEM_PRIVILEGE`
`READ`	`REAL`	`RECORD_VERSION`
`RECREATE`	`RECURSIVE`	`REFERENCES`
`REGR_AVGX`	`REGR_AVGY`	`REGR_COUNT`
`REGR_INTERCEPT`	`REGR_R2`	`REGR_SLOPE`
`REGR_SXX`	`REGR_SXY`	`REGR_SYY`
`RELATIVE`	`RELEASE`	`REPLACE`
`REQUESTS`	`RESERV`	`RESERVING`
`RESET`	`RESETTING`	`RESTART`
`RESTRICT`	`RETAIN`	`RETURN`
`RETURNING`	`RETURNING_VALUES`	`RETURNS`
`REVERSE`	`REVOKE`	`RIGHT`
`ROLE`	`ROLLBACK`	`ROUND`
`ROW`	`ROWS`	`ROW_COUNT`
`ROW_NUMBER`	`RPAD`	`RSA_DECRYPT`
`RSA_ENCRYPT`	`RSA_PRIVATE`	`RSA_PUBLIC`
`RSA_SIGN_HASH`	`RSA_VERIFY_HASH`	`SALT_LENGTH`
`SAVEPOINT`	`SCALAR_ARRAY`	`SCHEMA`
`SCROLL`	`SECOND`	`SECURITY`
`SEGMENT`	`SELECT`	`SENSITIVE`
`SEQUENCE`	`SERVERWIDE`	`SESSION`
`SET`	`SHADOW`	`SHARED`
`SIGN`	`SIGNATURE`	`SIMILAR`
`SIN`	`SINGULAR`	`SINH`
`SIZE`	`SKIP`	`SMALLINT`
`SNAPSHOT`	`SOME`	`SORT`
`SOURCE`	`SPACE`	`SQL`
`SQLCODE`	`SQLSTATE`	`SQRT`
`STABILITY`	`START`	`STARTING`
`STARTS`	`STATEMENT`	`STATISTICS`
`STDDEV_POP`	`STDDEV_SAMP`	`SUBSTRING`
`SUB_TYPE`	`SUM`	`SUSPEND`
`SYSTEM`	`TABLE`	`TAGS`
`TAN`	`TANH`	`TEMPORARY`
`THEN`	`TIES`	`TIME`
`TIMEOUT`	`TIMESTAMP`	`TIMEZONE_HOUR`
`TIMEZONE_MINUTE`	`TO`	`TOTALORDER`
`TRAILING`	`TRANSACTION`	`TRAPS`
`TRIGGER`	`TRIM`	`TRUE`
`TRUNC`	`TRUSTED`	`TWO_PHASE`
`TYPE`	`UNBOUNDED`	`UNCOMMITTED`
`UNDO`	`UNION`	`UNIQUE`
`UNKNOWN`	`UPDATE`	`UPDATING`
`UPPER`	`USAGE`	`USER`
`USING`	`UUID_TO_CHAR`	`VALUE`
`VALUES`	`VARBINARY`	`VARCHAR`
`VARIABLE`	`VARYING`	`VAR_POP`
`VAR_SAMP`	`VIEW`	`WAIT`
`WEEK`	`WEEKDAY`	`WHEN`
`WHERE`	`WHILE`	`WINDOW`
`WITH`	`WITHOUT`	`WORK`
`WRITE`	`YEAR`	`YEARDAY`
`ZONE`

Prev	Up	Next
Appendix C. Reserved Words and Keywords	Home	Appendix D. System Tables