IBPhoenix Development

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
This Site Uses:

InterBase 6.0 and SQL92 Reserved Words

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