The following table lists the words that are reserved by InterBase and
SQL92. The table separates the words into three categories:
- Words reserved by InterBase and SQL92
- Words reserved by InterBase only
- Words reserved by SQL92, but not by InterBase
InterBase & SQL 92 |
InterBase only |
|
SQL 92 only |
|
|
|
ABSOLUTE |
ACTION |
|
|
|
|
ACTIVE |
|
|
ADD |
|
|
|
|
ADMIN |
|
|
|
AFTER |
|
|
ALL |
|
|
|
|
|
|
ALLOCATE |
ALTER |
|
|
|
AND |
|
|
|
ANY |
|
|
|
ARE |
|
|
|
AS |
|
|
|
ASC |
|
|
|
|
ASCENDING |
|
|
|
|
|
ASSERTION |
AT |
|
|
|
|
|
|
AUTHORIZATION |
|
AUTO |
|
|
|
AUTODDL |
|
|
AVG |
|
|
|
|
BASED |
|
|
|
BASENAME |
|
|
|
BASE_NAME |
|
|
|
BEFORE |
|
|
BEGIN |
|
|
|
BETWEEN |
|
|
|
|
|
|
BIT |
|
|
|
BIT_LENGTH |
|
BLOB |
|
|
|
BLOBEDIT |
|
|
|
|
|
BOTH |
|
BUFFER |
|
|
BY |
|
|
|
|
CACHE |
|
|
CASCADE |
|
|
|
|
|
|
CASCADED |
|
|
|
CASE |
CAST |
|
|
|
|
|
|
CATALOG |
CHAR |
|
|
|
CHARACTER |
|
|
|
CHAR_LENGTH |
|
|
|
CHARACTER_LENGTH |
|
|
|
CHECK |
|
|
|
|
CHECK_POINT_LEN |
|
|
|
CHECK_POINT_LENGTH |
|
|
CLOSE |
|
|
|
|
|
|
COALESCE |
COLLATE |
|
|
|
COLLATION |
|
|
|
COLUMN |
|
|
|
COMMIT |
|
|
|
|
COMMITTED |
|
|
|
COMPILETIME |
|
|
|
COMPUTED |
|
|
|
CONDITIONAL |
|
|
CONNECT |
|
|
|
|
|
|
CONNECTION |
CONSTRAINT |
|
|
|
|
|
|
CONSTRAINTS |
|
CONTAINING |
|
|
CONTINUE |
|
|
|
|
|
|
CONVERT |
|
|
|
CORRESPONDING |
COUNT |
|
|
|
CREATE |
|
|
|
|
|
|
CROSS |
|
CSTRING |
|
|
CURRENT |
|
|
|
CURRENT_DATE |
|
|
|
CURRENT_TIME |
|
|
|
CURRENT_TIMESTAMP |
|
|
|
|
|
CURRENT_USER |
|
DATABASE |
|
|
DATE |
|
|
|
DAY |
|
|
|
|
DB_KEY |
|
|
|
|
|
DEALLOCATE |
|
DEBUG |
|
|
DEC |
|
|
|
DECIMAL |
|
|
|
DECLARE |
|
|
|
DEFAULT |
|
|
|
|
|
|
DEFERRABLE |
|
|
|
DEFERRED |
DELETE |
|
|
|
DESC |
|
|
|
|
DESCENDING |
|
|
DESCRIBE |
|
|
|
DESCRIPTOR |
|
|
|
|
|
|
DIAGNOSTICS |
DISCONNECT |
|
|
|
|
DISPLAY |
|
|
DISTINCT |
|
|
|
|
DO |
|
|
DOMAIN |
|
|
|
DOUBLE |
|
|
|
DROP |
|
|
|
|
ECHO |
|
|
|
EDIT |
|
|
ELSE |
|
|
|
END |
|
|
|
|
|
|
END-EXEC |
|
ENTRY_POINT |
|
|
ESCAPE |
|
|
|
|
EVENT |
|
|
|
|
|
EXCEPT |
EXCEPTION |
|
|
|
|
|
|
EXEC |
EXECUTE |
|
|
|
EXISTS |
|
|
|
|
EXIT |
|
|
|
EXTERN |
|
|
EXTERNAL |
|
|
|
EXTRACT |
|
|
|
|
|
|
FALSE |
FETCH |
|
|
|
|
FILE |
|
|
|
FILTER |
|
|
FLOAT |
|
|
|
FOR |
|
|
|
FOREIGN |
|
|
|
FOUND |
|
|
|
|
FREE_IT |
|
|
FROM |
|
|
|
FULL |
|
|
|
|
FUNCTION |
|
|
|
GDSCODE |
|
|
|
GENERATOR |
|
|
|
GEN_ID |
|
|
|
|
|
GET |
GLOBAL |
|
|
|
|
|
|
GO |
GOTO |
|
|
|
GRANT |
|
|
|
GROUP |
|
|
|
|
GROUP_COMMIT_WAIT |
|
GROUP_COMMIT_WAIT_TIME |
HAVING |
|
|
|
|
HELP |
|
|
HOUR |
|
|
|
|
|
|
IDENTITY |
|
IF |
|
|
IMMEDIATE |
|
|
|
IN |
|
|
|
|
INACTIVE |
|
|
|
INDEX |
|
|
INDICATOR |
|
|
|
|
INIT |
|
|
|
|
|
INITIALLY |
INNER |
|
|
|
INPUT |
|
|
|
|
INPUT_TYPE |
|
|
|
|
|
INSENSITIVE |
INSERT |
|
|
|
INT |
|
|
|
INTEGER |
|
|
|
|
|
|
INTERSECT |
|
|
|
INTERVAL |
INTO |
|
|
|
IS |
|
|
|
ISOLATION |
|
|
|
|
ISQL |
|
|
JOIN |
|
|
|
KEY |
|
|
|
|
|
|
LANGUAGE |
|
|
|
LAST |
|
LC_MESSAGES |
|
|
|
LC_TYPE |
|
|
|
|
|
LEADING |
LEFT |
|
|
|
|
LENGTH |
|
|
|
LEV |
|
|
LEVEL |
|
|
|
LIKE |
|
|
|
|
|
|
LOCAL |
|
LOGFILE |
|
|
|
LOG_BUFFER_SIZE |
|
|
|
LOG_BUF_SIZE |
|
|
|
LONG |
|
|
|
|
|
LOWER |
|
MANUAL |
|
|
|
|
|
MATCH |
MAX |
|
|
|
|
MAXIMUM |
|
|
|
MAXIMUM_SEGMENT |
|
|
|
MAX_SEGMENT |
|
|
|
MERGE |
|
|
|
MESSAGE |
|
|
MIN |
|
|
|
|
MINIMUM |
|
|
MINUTE |
|
|
|
|
|
|
MODULE |
|
MODULE_NAME |
|
|
MONTH |
|
|
|
NAMES |
|
|
|
NATIONAL |
|
|
|
NATURAL |
|
|
|
NCHAR |
|
|
|
|
|
|
NEXT |
NO |
|
|
|
|
NOAUTO |
|
|
NOT |
|
|
|
NULL |
|
|
|
|
|
|
NULLIF |
|
NUM_LOG_BUFS |
|
|
|
NUM_LOG_BUFFERS |
|
|
NUMERIC |
|
|
|
OCTET_LENGTH |
|
|
|
OF |
|
|
|
ON |
|
|
|
ONLY |
|
|
|
OPEN |
|
|
|
OPTION |
|
|
|
OR |
|
|
|
ORDER |
|
|
|
OUTER |
|
|
|
OUTPUT |
|
|
|
|
OUTPUT_TYPE |
|
|
|
OVERFLOW |
|
|
|
|
|
OVERLAPS |
|
|
|
PAD |
|
PAGE |
|
|
|
PAGELENGTH |
|
|
|
PAGES |
|
|
|
PAGE_SIZE |
|
|
|
PARAMETER |
|
|
|
|
|
PARTIAL |
|
PASSWORD |
|
|
|
PLAN |
|
|
POSITION |
|
|
|
|
POST_EVENT |
|
|
PRECISION |
|
|
|
PREPARE |
|
|
|
|
|
|
PRESERVE |
PRIMARY |
|
|
|
|
|
|
PRIOR |
PRIVILEGES |
|
|
|
PROCEDURE |
|
|
|
PUBLIC |
|
|
|
|
QUIT |
|
|
|
RAW_PARTITIONS |
|
|
|
RDB$DB_KEY |
|
|
READ |
|
|
|
REAL |
|
|
|
|
RECORD_VERSION |
|
|
REFERENCES |
|
|
|
|
|
|
RELATIVE |
|
RELEASE |
|
|
|
RESERV |
|
|
|
RESERVING |
|
|
RESTRICT |
|
|
|
|
RETAIN |
|
|
|
RETURN |
|
|
|
RETURNING_VALUES |
|
|
|
RETURNS |
|
|
REVOKE |
|
|
|
RIGHT |
|
|
|
|
ROLE |
|
|
ROLLBACK |
|
|
|
|
|
|
ROWS |
|
RUNTIME |
|
|
SCHEMA |
|
|
|
|
|
|
SCROLL |
|
SECOND |
|
|
|
|
|
SECTION |
SELECT |
|
|
|
|
|
|
SESSION |
|
|
|
SESSION_USER |
SET |
|
|
|
|
SHADOW |
|
|
|
SHARED |
|
|
|
SHELL |
|
|
|
SHOW |
|
|
|
SINGULAR |
|
|
SIZE |
|
|
|
SMALLINT |
|
|
|
|
SNAPSHOT |
|
|
SOME |
|
|
|
|
SORT |
|
|
|
|
|
SPACE |
SQL |
|
|
|
SQLCODE |
|
|
|
SQLERROR |
|
|
|
|
|
|
SQLSTATE |
SQLWARNING |
|
|
|
|
STABILITY |
|
|
|
STARTING |
|
|
|
STARTS |
|
|
|
STATEMENT |
|
|
|
STATIC |
|
|
|
STATISTICS |
|
|
|
SUB_TYPE |
|
|
|
|
|
SUBSTRING |
SUM |
|
|
|
|
SUSPEND |
|
|
|
|
|
SYSTEM_USER |
TABLE |
|
|
|
|
|
|
TEMPORARY |
|
TERMINATOR |
|
|
THEN |
|
|
|
TIME |
|
|
|
TIMESTAMP |
|
|
|
|
|
|
TIMEZONE_HOUR |
|
|
|
TIMEZONE_MINUTE |
TO |
|
|
|
|
|
|
TRAILING |
TRANSACTION |
|
|
|
TRANSLATE |
|
|
|
TRANSLATION |
|
|
|
|
TRIGGER |
|
|
TRIM |
|
|
|
|
|
|
TRUE |
|
TYPE |
|
|
|
UNCOMMITTED |
|
|
UNION |
|
|
|
UNIQUE |
|
|
|
|
|
|
UNKNOWN |
UPDATE |
|
|
|
UPPER |
|
|
|
|
|
|
USAGE |
USER |
|
|
|
USING |
|
|
|
VALUE |
|
|
|
VALUES |
|
|
|
VARCHAR |
|
|
|
|
VARIABLE |
|
|
VARYING |
|
|
|
|
VERSION |
|
|
VIEW |
|
|
|
|
WAIT |
|
|
|
WEEKDAY |
|
|
WHEN |
|
|
|
WHENEVER |
|
|
|
WHERE |
|
|
|
|
WHILE |
|
|
WITH |
|
|
|
WORK |
|
|
|
WRITE |
|
|
|
YEAR |
|
|
|
|
YEARDAY |
|
|
|
|
|
ZONE | |