Reserved Words
The following keywords are reserved in Mimer SQL statements.
They must be enclosed in quotation marks if you want to use them as SQL identifiers.
| ALL
|
ALLOCATE
|
ALTER
|
AND
|
| ANY
|
AS
|
ASYMMETRIC
|
AT
|
| ATOMIC
|
AUTHORIZATION
|
BEGIN
|
BETWEEN
|
| BOTH
|
BY
|
CALL
|
CALLED
|
| CASE
|
CAST
|
CHECK
|
CLOSE
|
| COLLATE
|
COLUMN
|
COMMIT
|
CONDITION
|
| CONNECT
|
CONSTRAINT
|
CORRESPONDING
|
CREATE
|
| CROSS
|
CURRENT
|
CURRENT_DATE
|
CURRENT_PATH
|
| CURRENT_TIME
|
CURRENT_TIMESTAMP
|
CURRENT_USER
|
CURSOR
|
| DAY
|
DEALLOCATE
|
DECLARE
|
DEFAULT
|
| DELETE
|
DESCRIBE
|
DETERMINISTIC
|
DISCONNECT
|
| DISTINCT
|
DO
|
DROP
|
ELSE
|
| ELSEIF
|
END
|
ESCAPE
|
EXCEPT
|
| EXECUTE
|
EXISTS
|
EXTERNAL
|
FALSE
|
| FETCH
|
FIRST
|
FOR
|
FOREIGN
|
| FROM
|
FULL
|
FUNCTION
|
GET
|
| GLOBAL
|
GRANT
|
GROUP
|
HANDLER
|
| HAVING
|
HOLD
|
HOUR
|
IDENTITY
|
| IF
|
IN
|
INDICATOR
|
INNER
|
| INOUT
|
INSERT
|
INTERSECT
|
INTERVAL
|
| INTO
|
IS
|
ITERATE
|
JOIN
|
| LANGUAGE
|
LARGE
|
LEADING
|
LEAVE
|
| LEFT
|
LIKE
|
LOCAL
|
LOCALTIME
|
| LOCALTIMESTAMP
|
LOOP
|
MATCH
|
MEMBER
|
| METHOD
|
MINUTE
|
MODIFIES
|
MODULE
|
| MONTH
|
NATIONAL
|
NATURAL
|
NEW
|
| NEXT
|
NO
|
NOT
|
NULL
|
| OF
|
OFFSET
|
OLD
|
ON
|
| OPEN
|
OR
|
ORDER
|
OUT
|
| OVERLAPS
|
PARAMETER
|
PRECISION
|
PREPARE
|
| PRIMARY
|
PROCEDURE
|
READS
|
REFERENCES
|
| REFERENCING
|
RELEASE
|
REPEAT
|
RESIGNAL
|
| RESULT
|
RETURN
|
RETURNS
|
REVOKE
|
| RIGHT
|
ROLLBACK
|
ROW
|
ROWS
|
| SCROLL
|
SECOND
|
SELECT
|
SESSION_USER
|
| SET
|
SIGNAL
|
SOME
|
SPECIFIC
|
| SQL
|
SQLEXCEPTION
|
SQLSTATE
|
SQLWARNING
|
| START
|
STATIC
|
SYMMETRIC
|
SYSTEM_USER
|
| TABLE
|
THEN
|
TIMEZONE_HOUR
|
TIMEZONE_MINUTE
|
| TO
|
TRAILING
|
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 the SQL Standard
The following keywords are reserved in standard SQL, but not in Mimer SQL:
| ARE
|
ARRAY
|
ASENSITIVE
|
BIGINT
|
| BINARY
|
BLOB
|
BOOLEAN
|
CASCADED
|
| CHAR
|
CHARACTER
|
CLOB
|
CUBE
|
| CURRENT_CATALOG
|
CURRENT_DEFAULT_
TRANSFORM_GROUP
|
CURRENT_ROLE
|
CURRENT_SCHEMA
|
| CURRENT_TRANSFORM
_GROUP_FOR_TYPE
|
CYCLE
|
DATE
|
DEC
|
| DECIMAL
|
DEREF
|
DOUBLE
|
DYNAMIC
|
| EACH
|
ELEMENT
|
EXEC
|
FILTER
|
| FLOAT
|
FREE
|
GROUPING
|
INSENSITIVE
|
| INT
|
INTEGER
|
LATERAL
|
MERGE
|
| MULTISET
|
NCHAR
|
NCLOB
|
NONE
|
| NUMERIC
|
ONLY
|
OUTER
|
OVER
|
| PARTITION
|
RANGE
|
REAL
|
RECURSIVE
|
| REF
|
ROLLUP
|
SAVEPOINT
|
SCOPE
|
| SEARCH
|
SENSITIVE
|
SIMILAR
|
SMALLINT
|
| SPECIFICTYPE
|
SUBMULTISET
|
SYSTEM
|
TABLESAMPLE
|
| TIME
|
TIMESTAMP
|
TRANSLATION
|
TREAT
|
| TRUNCATE
|
UESCAPE
|
UNNEST
|
VARBINARY
|
| VARCHAR
|
WHENEVER
|
WINDOW
|
WITHIN
|
