Reserved Words

They must be enclosed in quotation marks if you want to use them as SQL identifiers.


ALL	ALLOCATE	ALTER	AND
ANY	ARE	AS	AT
AUTHORIZATION	BEGIN	BETWEEN	BOTH
BY	CALL	CASCADED	CASE
CAST	CHARACTER	CHECK	CLOSE
COLLATE	COLUMN	COMMIT	CONNECT
CONSTRAINT	CORRESPONDING	CREATE	CROSS
CURRENT	CURRENT_DATE	CURRENT_PATH	CURRENT_TIME
CURRENT_TIMESTAMP	CURRENT_USER	CURSOR	DAY
DEALLOCATE	DECLARE	DEFAULT	DELETE
DESCRIBE	DISCONNECT	DISTINCT	DO
DROP	EACH	ELSE	ELSEIF
END	EXCEPT	EXECUTE	EXISTS
FALSE	FETCH	FOR	FOREIGN
FROM	FULL	FUNCTION	GET
GLOBAL	GRANT	GROUP	HAVING
HOLD	HOUR	IDENTITY	IF
IN	INDICATOR	INNER	INOUT
INSERT	INTERSECT	INTERVAL	INTO
IS	JOIN	LARGE	LEADING
LEAVE	LEFT	LIKE	LOCAL
LOCALTIME	LOCALTIMESTAMP	LOOP	MATCH
MINUTE	MODULE	MONTH	NATIONAL
NATURAL	NEW	NOT	NULL
OF	OLD	ON	ONLY
OPEN	OR	ORDER	OUT
OUTER	OVERLAPS	PRECISION	PREPARE
PRIMARY	PROCEDURE	REFERENCES	REFERENCING
RELEASE	REPEAT	RESIGNAL	RETURN
REVOKE	RIGHT	ROLLBACK	ROW
SECOND	SELECT	SESSION_USER	SET
SIGNAL	SOME	SPECIFIC	SQLEXCEPTION
SQLSTATE	SQLWARNING	START	SYSTEM_USER
TABLE	THEN	TIMEZONE_HOUR	TIMEZONE_MINUTE
TO	TRAILING	TRANSLATION	TRIGGER
TRUE	UNION	UNIQUE	UNKNOWN
UNTIL	UPDATE	USER	USING
VALUE	VALUES	VARYING	WHEN
WHERE	WHILE	WITH	WITHOUT
YEAR

Note: The keyword END-EXEC is reserved specifically in statements embedded in COBOL programs.

An identifier in Mimer SQL can be protected against conflicting with potential reserved words by including a digit or an underscore in the identifier and by ensuring that it does not begin with CURRENT_, SESSION_, SYSTEM_ or TIMEZONE_.

Reserved Keywords in SQL-99


ABS	ABSOLUTE	ACTION	ADD
AFTER	ARRAY	ASC	ASENSITIVE
ASSERTION	ASYMMETRIC	ATOMIC	AVG
BEFORE	BINARY	BIT	BIT_LENGTH
BLOB	BOOLEAN	BREADTH	CALLED
CARDINALITY	CASCADE	CATALOG	CHAR
CHAR_LENGTH	CHARACTER_LENGTH	CLOB	COALESCE
COLLATION	CONDITION	CONNECTION	CONSTRAINTS
CONSTRUCTOR	CONTAINS	CONTINUE	CONVERT
COUNT	CUBE	CURRENT_ROLE	CYCLE
DATA	DATE	DEC	DECIMAL
DEFERRABLE	DEFERRED	DEPTH	DEREF
DESC	DESCRIPTOR	DETERMINISTIC	DIAGNOSTICS
DOMAIN	DOUBLE	DYNAMIC	EQUALS
ESCAPE	EVERY	EXCEPTION	EXEC
EXIT	EXTERNAL	EXTRACT	FIRST
FLOAT	FOUND	FREE	GENERAL
GO	GOTO	GROUPING	HANDLER
IMMEDIATE	INITIALLY	INPUT	INSENSITIVE
INT	INTEGER	ISOLATION	ITERATE
KEY	LANGUAGE	LAST	LATERAL
LEVEL	LOCATOR	LOWER	MAP
MAX	METHOD	MIN	MOD
MODIFIES	NAMES	NCHAR	NCLOB
NEXT	NO	NONE	NULLIF
NUMERIC	OBJECT	OCTET_LENGTH	OPTION
ORDINALITY	OUTPUT	OVERLAY	PAD
PARAMETER	PARTIAL	PATH	POSITION
PRESERVE	PRIOR	PRIVILEGES	PUBLIC
READ	READS	REAL	RECURSIVE
REF	RELATIVE	RESTRICT	RESULT
RETURNS	ROLE	ROLLUP	ROUTINE
ROWS	SAVEPOINT	SCHEMA	SCOPE
SCROLL	SEARCH	SECTION	SENSITIVE
SESSION	SETS	SIMILAR	SIZE
SMALLINT	SPACE	SPECIFICTYPE	SQL
SUBSTRING	SUM	SYMMETRIC	SYSTEM
TEMPORARY	TIME	TIMESTAMP	TRANSACTION
TRANSLATE	TREAT	TRIM	UNDER
UNDO	UNNEST	UPPER	USAGE
VARCHAR	WHENEVER	VIEW	WORK
WRITE	ZONE