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.


#	;	:	@


ABORT	ACCELERATED	ADD
AFTER	ALL	ALTER
AND	ANSI-PADDING	ANY
AS	ASC	ATOMIC
AVG


BEFORE	BEGIN	BETWEEN
BORDER	BY


CALL	CACHED_PROCEDURES	CASCADE
CASE	CAST	CHECK
CLOSE	COALESCE	COLLATE
COLUMN	COMMIT	COMMITTED
CONSTRAINT	CONVERT	COUNT
CREATE	CREATESP	CREATETAB
CREATEVIEW	CROSS	CS
CURDATE	CURRENT	CURSOR
CURTIME


DATA_PATH	DATABASE	DATETIMEMILLISECONDS
DBO	DBSEC_AUTHENTICATION	DBSEC_AUTHORIZATION
DCOMPRESS	DDF	DECIMALSEPARATORCOMMA
DECLARE	DEFAULT	DEFAULTCOLLATE
DELETE	DENY	DESC
DIAGNOSTICS	DICTIONARY	DICTIONARY_PATH
DISTINCT	DO	DROP
DSN


EACH	ELSE	ENCODING
END	ENFORCED	EX
EXCLUSIVE	EXEC	EXECUTE
EXISTING	EXISTS	EXPR


FETCH	FILES	FN
FOR	FOREIGN	FROM
FULL	FUNCTION


GLOBAL_QRYPLAN	GRANT	GROUP


HANDLER	HAVING


IDENTITY	IF	IN
INDEX	INNER	INOUT
INSERT	INTEGRITY	INTERNAL
INTO	IS	ISOLATION


LEAVE	LEFT	LEGACYOWNERNAME
LEVEL	LIKE	LINKDUP
LOGIN	LOOP


MAX	MIN	MODE
MODIFIABLE	MODIFY


NEW	NEXT	NO
NO_REFERENTIAL_INTEGRITY	NORMAL	NOT
NOW	NULL


OF	OFF	OLD
ON	ONLY	OPEN
OPTINNERJOIN	OR	ORDER
OUT	OUTER	OWNER


PAGESIZE	PARTIAL	PASSWORD
PCOMPRESS	PRED	PRIMARY
PRINT	PROCEDURE	PROCEDURES_CACHE
PSQL_MOVE	PSQL_PHYSICAL	PSQL_POSITION
PUBLIC


QRYPLAN	QRYPLANOUTPUT


READ	REFERENCES	REFERENCING
RELATIONAL	RELEASE	RENAME
REPEAT	REPEATABLE	REPLACE
RESTRICT	RETURN	RETURNS
REUSE_DDF	REVERSE	REVOKE
RIGHT	ROLLBACK	ROW
ROWCOUNT	ROWCOUNT2


SAVEPOINT	SECURITY	SELECT
SERIALIZABLE	SESSIONID	SET
SIGNAL	SIZE	SPID
SQLSTATE	SSP_EXPR	SSP_PRED
START	STDEV	SUM
SVBEGIN	SVEND


T	TABLE	THEN
TO	TOP	TRANSACTION
TRIGGER	TRIGGERSTAMPMISC	TRUEBITCREATE
TRUENULLCREATE	TS


UNCOMMITTED	UNION	UNIQUE
UNIQUEIDENTIFIER	UNTIL	UPDATE
USER	USING


V1_METADATA	V2_METADATA	VALUES
VIEW


WHEN	WHERE	WHILE
WITH	WORK	WRITE