SQL Reserved Words
Below is list of words which are reserved for use in SQL statements. Avoid using these reserved words whenever you name a dataset, field or index.
If a field or index must have a reserved word as its name, enclose the name in quotation marks and/or prefix any reference to it with the dataset name.
| A | |||
|
ACTIVE ADD ASC AUTOINC |
ALL ALTER ASCENDING AVG |
AFTER ANY AT |
AFTER AS AUTO
|
| B | |||
|
BASE_NAME BEFORE BEGIN |
BETWEEN BLOB |
BOOLEAN BOTH |
BY BYTES |
| C | |||
|
CACHE CAST CHAR CHARACTER CHECK_POINT_LENGTH |
COLLATE COLUMN COMMIT COMMITTED COMPUTED |
CONDITIONAL CONSTRAINT CONTAINING COUNT CREATE |
CSTRING CURRENT CURSOR |
| D | |||
|
DATABASE DATE DAY DEBUG |
DEC DECIMAL DECLARE DEFAULT |
DELETE DESC DESCENDING DISTINCT |
DO DOMAIN DOUBLE DROP |
| E | |||
|
ELSE END ENTRY_POINT |
ESCAPE EXCEPTION EXECUTE |
EXISTS EXIT
|
EXTERNAL EXTRACT |
| F | |||
|
FILE FILTER |
FLOAT FOR |
FOREIGN FROM |
FULL FUNCTION |
| G | |||
|
GDSCODE GROUP_COMMIT |
GENERATOR
|
GEN_ID
|
GRANT |
| H | |||
| HAVING | HOUR | ||
| I | |||
|
IF IN INT |
INACTIVE INDEX INNER |
INPUT_TYPE INSERT INTEGER |
INTO IS ISOLATION |
| J - K | |||
| JOIN | KEY | ||
| L | |||
|
LONG LEADING |
LENGTH LEFT |
LOGFILE LEVEL |
LOWER LIKE |
| M | |||
|
MANUAL MAX MAXIMUM_SEGMENT |
MERGE MESSAGE MIN |
MINUTE MODULE_NAME |
MONEY MONTH |
| N | |||
|
NAMES NO |
NATIONAL NOT |
NATURAL NULL |
NCHAR NUMERIC |
| O | |||
|
OF ON ONLY |
OPTION OR |
ORDER OUTER |
OUTPUT TYPE OVERFLOW |
| P | |||
|
PAGE_SIZE PAGE PAGES PARAMETER |
PLAN POSITION POST_EVENT
|
PROCEDURE PROTECTED PASSWORD |
PRECISION PRIMARY PRIVILEGES |
| R | |||
|
RAW_PARTITIONS RDB$DB_KEY READ REAL |
RECORD_VERSION REFERENCES RESERV RESERVING |
RETAIN RETURNING_VALUES RETURNS |
REVOKE RIGHT ROLLBACK |
| S | |||
|
SECOND SEGMENT SELECT SHARED SET SHARED |
SHADOW SCHEMA SINGULAR SIZE SMALLINT SNAPSHOT |
SOME SORT SQLCODE STABILITY STARTING SUM |
STARTS STATISTICS SUB_TYPE SUBSTRING SUSPEND |
| T | |||
|
TABLE THEN TIME |
TIMESTAMP TIMEZONE_HOUR TIMEZONE_MINUTE |
TO TRAILING TRANSACTION |
TRIGGER TRIM |
| U | |||
|
UNCOMMITTED UNION |
UNIQUE UPDATE |
UPPER | USER |
| V | |||
|
VALUE VALUES |
VARCHAR VARIABLE |
VARYING | VIEW |
| W - Y | |||
|
WAIT WHEN |
WHERE WHILE |
WITH WORK |
WRITE YEAR |
The following operators are commonly used in SQL statements. Avoid using these characters when you name a dataset, a field or an index.
|| , - , * , / , <> , < , > , ,(comma) , = , <= , >= , ~= , != , ^= , ( , ,)