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 TIME is 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.

WEEKDAY

YEARDAY

Advance To: