Appendix B: Reserved words and keywords – full lists
<< Appendix A: Notes | FB 2.5 Language Reference | Appendix C: Document History >>
Appendix B: Reserved words and keywords – full lists
Reserved words
Full list of reserved words in Firebird 2.5:
ADD ADMIN ALL ALTER AND ANY AS AT AVG BEGIN BETWEEN BIGINT BIT_LENGTH BLOB BOTH BY CASE CAST CHAR CHAR_LENGTH CHARACTER CHARACTER_LENGTH CHECK CLOSE COLLATE COLUMN COMMIT CONNECT CONSTRAINT COUNT 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 DISCONNECT DISTINCT DOUBLE DROP ELSE END ESCAPE EXECUTE EXISTS EXTERNAL EXTRACT FETCH FILTER FLOAT FOR FOREIGN FROM FULL FUNCTION GDSCODE GLOBAL GRANT GROUP HAVING HOUR IN INDEX INNER INSENSITIVE INSERT INT INTEGER INTO IS JOIN LEADING LEFT LIKE LONG LOWER MAX MAXIMUM_SEGMENT MERGE MIN MINUTE MONTH NATIONAL NATURAL NCHAR NO NOT NULL NUMERIC OCTET_LENGTH OF ON ONLY OPEN OR ORDER OUTER PARAMETER PLAN POSITION POST_EVENT PRECISION PRIMARY PROCEDURE RDB$DB_KEY REAL RECORD_VERSION RECREATE RECURSIVE REFERENCES RELEASE RETURNING_VALUES RETURNS REVOKE RIGHT ROLLBACK ROW_COUNT ROWS SAVEPOINT SECOND SELECT SENSITIVE SET SIMILAR SMALLINT SOME SQLCODE SQLSTATE (2.5.1) START SUM TABLE THEN TIME TIMESTAMP TO TRAILING TRIGGER TRIM UNION UNIQUE UPDATE UPPER USER USING VALUE VALUES VARCHAR VARIABLE VARYING VIEW WHEN WHERE WHILE WITH YEAR
Keywords
The following terms have a special meaning in Firebird 2.5 DSQL. Some of them are also reserved words, others aren't.
!< ^< ^= ^> , := != !> ( ) < <= <> = > >= || ~< ~= ~> ABS ACCENT ACOS ACTION ACTIVE ADD ADMIN AFTER ALL ALTER ALWAYS AND ANY AS ASC ASCENDING ASCII_CHAR ASCII_VAL ASIN AT ATAN ATAN2 AUTO AUTONOMOUS AVG BACKUP BEFORE BEGIN BETWEEN BIGINT BIN_AND BIN_NOT BIN_OR BIN_SHL BIN_SHR BIN_XOR BIT_LENGTH BLOB BLOCK BOTH BREAK BY CALLER CASCADE CASE CAST CEIL CEILING CHAR CHAR_LENGTH CHAR_TO_UUID CHARACTER CHARACTER_LENGTH CHECK CLOSE COALESCE COLLATE COLLATION COLUMN COMMENT COMMIT COMMITTED COMMON COMPUTED CONDITIONAL CONNECT CONSTRAINT CONTAINING COS COSH COT COUNT CREATE CROSS CSTRING CURRENT CURRENT_CONNECTION CURRENT_DATE CURRENT_ROLE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_TRANSACTION CURRENT_USER CURSOR DATA DATABASE DATE DATEADD DATEDIFF DAY DEC DECIMAL DECLARE DECODE DEFAULT DELETE DELETING DESC DESCENDING DESCRIPTOR DIFFERENCE DISCONNECT DISTINCT DO DOMAIN DOUBLE DROP ELSE END ENTRY_POINT ESCAPE EXCEPTION EXECUTE EXISTS EXIT EXP EXTERNAL EXTRACT FETCH FILE FILTER FIRST FIRSTNAME FLOAT FLOOR FOR FOREIGN FREE_IT FROM FULL FUNCTION GDSCODE GEN_ID GEN_UUID GENERATED GENERATOR GLOBAL GRANT GRANTED GROUP HASH HAVING HOUR IF IGNORE IIF IN INACTIVE INDEX INNER INPUT_TYPE INSENSITIVE INSERT INSERTING INT INTEGER INTO IS ISOLATION JOIN KEY LAST LASTNAME LEADING LEAVE LEFT LENGTH LEVEL LIKE LIMBO LIST LN LOCK LOG LOG10 LONG LOWER LPAD MANUAL MAPPING MATCHED MATCHING MAX MAXIMUM_SEGMENT MAXVALUE MERGE MIDDLENAME MILLISECOND MIN MINUTE MINVALUE MOD MODULE_NAME MONTH NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NULL NULLIF NULLS NUMERIC OCTET_LENGTH OF ON ONLY OPEN OPTION OR ORDER OS_NAME OUTER OUTPUT_TYPE OVERFLOW OVERLAY PAD PAGE PAGE_SIZE PAGES PARAMETER PASSWORD PI PLACING PLAN POSITION POST_EVENT POWER PRECISION PRESERVE PRIMARY PRIVILEGES PROCEDURE PROTECTED RAND RDB$DB_KEY READ REAL RECORD_VERSION RECREATE RECURSIVE REFERENCES RELEASE REPLACE REQUESTS RESERV RESERVING RESTART RESTRICT RETAIN RETURNING RETURNING_VALUES RETURNS REVERSE REVOKE RIGHT ROLE ROLLBACK ROUND ROW_COUNT ROWS RPAD SAVEPOINT SCALAR_ARRAY SCHEMA SECOND SEGMENT SELECT SENSITIVE SEQUENCE SET SHADOW SHARED SIGN SIMILAR SIN SINGULAR SINH SIZE SKIP SMALLINT SNAPSHOT SOME SORT SOURCE SPACE SQLCODE SQLSTATE (2.5.1) SQRT STABILITY START STARTING STARTS STATEMENT STATISTICS SUB_TYPE SUBSTRING SUM SUSPEND TABLE TAN TANH TEMPORARY THEN TIME TIMEOUT TIMESTAMP TO TRAILING TRANSACTION TRIGGER TRIM TRUNC TWO_PHASE TYPE UNCOMMITTED UNDO UNION UNIQUE UPDATE UPDATING UPPER USER USING UUID_TO_CHAR VALUE VALUES VARCHAR VARIABLE VARYING VIEW WAIT WEEK WEEKDAY WHEN WHERE WHILE WITH WORK WRITE YEAR YEARDAY
back to top of page
<< Appendix A: Notes | FB 2.5 Language Reference | Appendix C: Document History >>
