Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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
RECURSIVE
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
TREAT
TRIGGER
TRUE
UNION
UNIQUE
UNKNOWN
UNTIL
UPDATE
USER
USING
VALUE
VALUES
VARYING
WHEN
WHERE
WHILE
WITH
WITHOUT
YEAR


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

Reserved Keywords in the SQL Standard

The following keywords are reserved in the SQL-2016 standard, but not in Mimer SQL:

ABS
ACOS
ARE
ARRAY
ARRAY_AGG
ARRAY_MAX_
CARDINALITY
ASENSITIVE
ASIN
ATAN
AVG
BEGIN_FRAME
BEGIN_PARTITION
BIGINT
BINARY
BLOB
BOOLEAN
CARDINALITY
CASCADED
CEIL
CEILING
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CLASSIFIER
CLOB
COALESCE
COLLECT
CONTAINS
CONVERT
COPY
CORR
COS
COSH
COUNT
COVAR_POP
COVAR_SAMP
CUBE
CUME_DIST
CURRENT_CATALOG
CURRENT_DEFAULT_
TRANSFORM_GROUP
CURRENT_ROLE
CURRENT_ROW
CURRENT_SCHEMA
CURRENT_TRANSFORM
_GROUP_FOR_TYPE
CYCLE
DATE
DEC
DECIMAL
DECFLOAT
DEFINE
DENSE_RANK
DEREF
DOUBLE
DYNAMIC
EACH
ELEMENT
EMPTY
END_FRAME
END_PARTITION
END-EXEC
EQUALS
EVERY
EXEC
EXP
EXTRACT
FILTER
FIRST_VALUE
FLOAT
FLOOR
FRAME_ROW
FREE
FUSION
GROUPING
GROUPS
INITIAL
INSENSITIVE
INT
INTEGER
INTERSECTION
JSON_ARRAY
JSON_ARRAYAGG
JSON_EXISTS
JSON_OBJECT
JSON_OBJECTAGG
JSON_QUERY
JSON_TABLE
JSON_TABLE_
PRIMITIVE
JSON_VALUE
LAG
LAST_VALUE
LATERAL
LEAD
LIKE_REGEX
LISTAGG
LN
LOG
LOG10
LOWER
MATCH_NUMBER
MATCH_RECOGNIZE
MATCHES
MAX
MERGE
MIN
MOD
MULTISET
NCHAR
NCLOB
NONE
NORMALIZE
NTH_VALUE
NTILE
NULLIF
NUMERIC
OCTET_LENGTH
OCCURRENCES_REGEX
OMIT
ONE
ONLY
OUTER
OVER
OVERLAY
PARTITION
PATTERN
PER
PERCENT
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
PERIOD
PORTION
POSITION
POSITION_REGEX
POWER
PRECEDES
PTF
RANGE
RANK
REAL
REF
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
ROLLUP
ROW_NUMBER
RUNNING
SAVEPOINT
SCOPE
SEARCH
SEEK
SENSITIVE
SHOW
SIMILAR
SIN
SINH
SKIP
SMALLINT
SPECIFICTYPE
SQL
SQRT
STDDEV_POP
STDDEV_SAMP
SUBMULTISET
SUBSET
SUBSTRING
SUBSTRING_REGEX
SUCCEEDS
SUM
SYSTEM
SYSTEM_TIME
TABLESAMPLE
TAN
TANH
TIME
TIMESTAMP
TRANSLATE
TRANSLATE_REGEX
TRANSLATION
TRIM
TRIM_ARRAY
TRUNCATE
UESCAPE
UNNEST
UPPER
VALUE_OF
VAR_POP
VAR_SAMP
VARBINARY
VARCHAR
VERSIONING
WHENEVER
WIDTH_BUCKET

WINDOW
WITHIN



Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX