Pervasive logo

Prev SQL Engine Reference Next

Reserved Words


Each of the symbols or words listed below has a special meaning when processed by the SRDE, unless it is delimited by double-quotes. Using one of these words as a table or object name without double quotes will cause an error.

See also the next section, Words to Avoid .

Symbols
#
;
:
@
A
ABORT
ABSOLUTE
ACCELERATED
ACTION
ADD
AFTER
ALL
ALTER
AND
ANY
AS
ASC
ATOMIC
AUTHORIZATION
AVG
B
BEFORE
BEGIN/BEGINS
BETWEEN
BINARYNULL
BIND
BLANK
BY


C
CALL
CASCADE
CASE
CHAIN
CHARACTER
CHECK
CLOSE
COBOL
COLLATE
COLUMN
COMMIT
COMMITTED
CONDITION
CONSTRAINT
CONTINUE
CONVERT
COUNT
CREATE
CREATETAB
CROSS
CS
CURDATE
CURRENT
CURSOR
CURTIME


D
D
DATABASE
DCOMPRESS
DECIMALSEPARATORCOMMA
DECLARE
DEFAULT
DELETE
DESC
DIAGNOSTICS
DICTIONARY
DISTINCT
DO
DROP


E
EACH
ELSE
ELSEIF
END
ESCAPE
EX
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXTERNAL

F
FETCH
FIRST
FN
FOR
FOREIGN
FROM
FULL


G
GRANT
GROUP

H
HANDLER
HAVING
HOUR
I
IDENTITY
IF
IN
INCLUDE
INDEX
INNER
INOUT
INSERT
INTERNAL
INTO
IS
ISOLATION
J

JOIN

K

KEY

L
LANGUAGE
LAST
LEAVE
LEFT
LEGACYOWNERNAME
LENGTH
LEVEL
LIKE
LOGICAL
LOGIN
LOOP
LOWER
M
MAX
MILLISECOND
MIN
MINUTE
MODIFIABLE
MODIFY
MODULE
MONEY
MONTH
N
NEW
NEXT
NO
NORMAL
NOT
NOTFOUND
NOW
NULL

O
OF
OFF
OLD
ON
ONLY
OPEN
OPENMODE
OPTION
OR
ORDER
OUT
OUTER
OWNER
OWNERACCESS

P
PAGESIZE
PREALLOCATE
PREPARE
PRIMARY
PRINT
PRIOR
PRIVILEGES
PROCEDURE
PUBLIC
R
RANGE
READ
READONLY
REFERENCES
REFERENCING
RELATIVE
RELEASE
REPEAT
REPEATABLE
REPLACE
REPLICATION
RESIGNAL
RESTRICT
RETURN
RETURNS
REVOKE
RIGHT
ROLLBACK
ROW
ROWCOUNT

S
SAVEPOINT
SCHEMA
SCROLL
SECURITY
SEG
SELECT
SERIALIZABLE
SET
SIGNAL
SIZE
SOME
SQLERROR
SQLEXCEPTIONS
SQLWARNINGS
SQLSTATE
SSP_EXPR
SSP_PRED
START
STATEMENT
STRINGNULL
SUM
SVBEGIN
SVEND

T
T
TABLE
THEN
THRESHOLD
TO
TOP
TRANSACTION
TRIGGER
TRIGGERSTAMPMISC
TRUENULLCREATE
TS
TYPE
U
UNCOMMITTED
UNDO
UNION
UNIQUE
UNTIL
UPDATABLE
UPDATE
UPPER
USER
USING


V
VALUE, VALUES
VERIFY
VIEW
W
WHEN
WHERE
WHILE
WITH
WORK
WRITE
Y

YEAR

Z

ZSTRING


Prev
SQL Reserved Words
Contents
Up
Check for Revisions
Next
Words to Avoid