InterBase Keywords
From InterBase
Go Up to Keywords
These keywords are reserved words in all dialects.
- Beginning with InterBase 6, you cannot create objects in a dialect 1 database that have any of these keywords as object names (identifiers).
- You can migrate a version 5 database that contains these keywords used as identifiers to version 6 or later dialect 1 without changing the object names: a column could be named “YEAR”, for instance.
- Version 5 clients can access these keyword identifiers without error.
- Version 6 and later clients cannot access keywords that are used as identifiers. In a dialect 1 database, you must change the names so that they are not keywords.
- If you migrate directly to dialect 3, you can retain the names, but you must delimit them with double quotes. To retain accessibility for older clients, put the names in all upper case. Delimited identifiers are case sensitive.
- Although
TIMEis a reserved word in version 6 and later dialect 1, you cannot use it as a data type because such databases guarantee data type compatibility with version 5 clients. - In dialect 3 databases and clients, any reserved word can be used as an identifier as long as it is delimited with double quotes.
ACTION
|
ACTIVE
|
ADD
|
ADMIN
|
AFTER
|
ALL
|
ALTER
|
AND
|
ANY
|
AS
|
ASC
|
ASCENDING
|
AT
|
AUTO
|
AUTODDL
|
AVG
|
BASED
|
BASENAME
|
BASE_NAME
|
BEFORE
|
BEGIN
|
BETWEEN
|
BLOB
|
BLOBEDIT
|
BOOLEAN
|
BUFFER
|
BY
|
CACHE
|
CASCADE
|
CASE
|
CAST
|
CHAR
|
CHARACTER
|
CHARACTER_LENGTH
|
CHAR_LENGTH
|
CHECK
|
CHECK_POINT_LEN
|
CHECK_POINT_LENGTH
|
COALESCE
|
COLLATE
|
COLLATION
|
COLUMN
|
COMMIT
|
COMMITTED
|
COMPILETIME
|
COMPUTED
|
CLOSE
|
CONDITIONAL
|
CONNECT
|
CONSTRAINT
|
CONTAINING
|
CONTINUE
|
COUNT
|
CREATE
|
CSTRING
|
CURRENT
|
CURRENT_DATE
|
CURRENT_TIME
|
CURRENT_TIMESTAMP
|
CURSOR
|
DATABASE
|
DATE
|
DAY
|
DB_KEY
|
DEBUG
|
DEC
|
DECIMAL
|
DECLARE
|
DECRYPT
|
DEFAULT
|
DELETE
|
DESC
|
DESCENDING
|
DESCRIBE
|
DESCRIPTOR
|
DISCONNECT
|
DISPLAY
|
DISTINCT
|
DO
|
DOMAIN
|
DOUBLE
|
DROP
|
ECHO
|
EDIT
|
ELSE
|
ENCRYPT
|
ENCRYPTION
|
END
|
ENTRY_POINT
|
ESCAPE
|
EVENT
|
EXCEPTION
|
EXECUTE
|
EXISTS
|
EXIT
|
EXTERN
|
EXTERNAL
|
EXTRACT
|
FALSE
|
FETCH
|
FILE
|
FILTER
|
FLOAT
|
FOR
|
FOREIGN
|
FOUND
|
FREE_IT
|
FROM
|
FULL
|
FUNCTION
|
GDSCODE
|
GENERATOR
|
GEN_ID
|
GLOBAL
|
GOTO
|
GRANT
|
GROUP
|
GROUP_COMMIT_WAIT
|
GROUP_COMMIT_WAIT_TIME
|
HAVING
|
HELP
|
HOUR
|
IF
|
IMMEDIATE
|
IN
|
INACTIVE
|
INDEX
|
INDICATOR
|
INIT
|
INNER
|
INPUT
|
INPUT_TYPE
|
INSERT
|
INT
|
INTEGER
|
INTO
|
IS
|
ISOLATION
|
ISQL
|
JOIN
|
KEY
|
LC_MESSAGES
|
LC_TYPE
|
LEFT
|
LENGTH
|
LEV
|
LEVEL
|
LIKE
|
LOGFILE
|
LOG_BUFFER_SIZE
|
LOG_BUF_SIZE
|
LONG
|
MANUAL
|
MAX
|
MAXIMUM
|
MAXIMUM_SEGMENT
|
MAX_SEGMENT
|
MERGE
|
MESSAGE
|
MIN
|
MINIMUM
|
MINUTE
|
MODULE_NAME
|
MONTH
|
NAMES
|
NATIONAL
|
NATURAL
|
NCHAR
|
NO
|
NOAUTO
|
NOT
|
NULL
|
NULLIF
|
NUMERIC
|
NUM_LOG_BUFS
|
NUM_LOG_BUFFERS
|
OCTET_LENGTH
|
OF
|
ON
|
ONLY
|
OPEN
|
OPTION
|
OR
|
ORDER
|
OUTER
|
OUTPUT
|
OUTPUT_TYPE
|
OVERFLOW
|
PAGE
|
PAGELENGTH
|
PAGES
|
PAGE_SIZE
|
PARAMETERS
|
PASSWORD
|
PERCENT
|
PLAN
|
POSITION
|
POST_EVENT
|
PRECISION
|
PREPARE
|
PRESERVE
|
PROCEDURE
|
PROTECTED
|
PRIMARY
|
PRIVILEGES
|
PUBLIC
|
QUIT
|
|
RAW_PARTITIONS
|
RDB$DB_KEY
|
READ
|
REAL
|
RECORD_VERSION
|
REFERENCES
|
RELEASE
|
RESERV
|
RESERVING
|
RESTRICT
|
RETAIN
|
RETURN
|
RETURNING_VALUES
|
RETURNS
|
REVOKE
|
RIGHT
|
ROLE
|
ROLLBACK
|
ROW
|
ROWS
|
RUNTIME
|
SCHEMA
|
SECOND
|
SEGMENT
|
SELECT
|
SET
|
SHADOW
|
SHARED
|
SHELL
|
SHOW
|
SINGULAR
|
SIZE
|
SMALLINT
|
SNAPSHOT
|
SOME
|
SORT
|
SQLCODE
|
SQLERROR
|
SQLWARNING
|
STABILITY
|
STARTING
|
STARTS
|
STATEMENT
|
STATIC
|
SUSPEND
|
TABLE
|
TABLESPACE
|
TEMPORARY
|
TERMINATOR
|
THEN
|
TIES
|
TIME
|
TIMESTAMP
|
TO
|
TRANSACTION
|
TRANSLATE
|
TRANSLATION
|
TRIGGER
|
TRIM
|
TRUE
|
TYPE
|
UNCOMMITTED
|
UNION
|
UNIQUE
|
UNKNOWN
|
UPDATE
|
UPPER
|
USER
|
USING
|
VALUE
|
VALUES
|
VARCHAR
|
VARIABLE
|
VARYING
|
VERSION
|
VIEW
|
WAIT
|
WEEKDAY
|
WHEN
|
WHENEVER
|
WHERE
|
WHILE
|
WITH
|
WORK
|
WRITE
|
YEAR
|
YEARDAY
|
- Note: The following keywords are specific to InterBase and are not part of the SQL standard.
|
|
|