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