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 |
AT |
ATOMIC |
| AUTHORIZATION |
BEGIN |
BETWEEN |
BOTH |
| BY |
CALL |
CASE |
CAST |
| CHARACTER |
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 |
FALSE |
FETCH |
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 |
| METHOD |
MINUTE |
MODIFIES |
MODULE |
| MONTH |
NATIONAL |
NATURAL |
NEW |
| NO |
NOT |
NULL |
OF |
| OLD |
ON |
OPEN |
OR |
| ORDER |
OUT |
OVERLAPS |
PRECISION |
| PREPARE |
PRIMARY |
PROCEDURE |
READS |
| REFERENCES |
REFERENCING |
RELEASE |
REPEAT |
| RESIGNAL |
RESULT |
RETURN |
RETURNS |
| REVOKE |
RIGHT |
ROLLBACK |
ROW |
| SCROLL |
SECOND |
SELECT |
SESSION_USER |
| SET |
SIGNAL |
SOME |
SPECIFIC |
| SQL |
SQLEXCEPTION |
SQLSTATE |
SQLWARNING |
| START |
STATIC |
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 SQL-2003
The following keywords are reserved in SQL-2003, but not in Mimer SQL:
| ARE |
ARRAY |
ASENSITIVE |
ASYMMETRIC |
| BIGINT |
BINARY |
BLOB |
BOOLEAN |
| CALLED |
CASCADED |
CHAR |
CLOB |
| CUBE |
CURRENT_DEFAULT_
TRANSFORM_GROUP |
CURRENT_ROLE |
CURRENT_TRANSFORM
_GROUP_FOR_TYPE |
| CYCLE |
DATE |
DEC |
DECIMAL |
| DEREF |
DOUBLE |
DYNAMIC |
EACH |
| ELEMENT |
EXEC |
EXTERNAL |
FILTER |
| FLOAT |
FREE |
GROUPING |
INSENSITIVE |
| INT |
INTEGER |
LATERAL |
MEMBER |
| MERGE |
MULTISET |
NCHAR |
NCLOB |
| NONE |
NUMERIC |
ONLY |
OUTER |
| OVER |
OVERLAY |
PARAMETER |
PARTITION |
| RANGE |
REAL |
RECURSIVE |
REF |
| ROLLUP |
ROWS |
SAVEPOINT |
SCOPE |
| SEARCH |
SENSITIVE |
SIMILAR |
SMALLINT |
| SPECIFICTYPE |
SUBMULTISET |
SYMMETRIC |
SYSTEM |
| TABLESAMPLE |
TIME |
TIMESTAMP |
TRANSLATE |
| TRANSLATION |
TREAT |
UESCAPE |
UNNEST |
| VARCHAR |
WHENEVER |
WINDOW |
WITHIN |
