helpinghand
search
needassistance
 

Standard SQL Reserved Words Summary

The following table lists all reserved words in the SQL standard, from SQL-99 to SQL-2011.

Note! Mimer SQL does not add any additional reserved words. In fact, Mimer SQL is using far less reserved words as compared with the standard (see below).

Keyword SQL-92 SQL-99 SQL-2003 SQL-2008 SQL-2011 Mimer SQL
ABS        
ABSOLUTE        
ACTION        
ADD        
AFTER          
ALL
ALLOCATE
ALTER
AND
ANY
ARE  
ARRAY    
ARRAY_AGG        
ARRAY_MAX_CARDINALITY          
AS
ASC        
ASENSITIVE    
ASSERTION          
ASYMMETRIC  
AT
ATOMIC  
AUTHORIZATION
AVG      
BEFORE          
BEGIN
BEGIN_FRAME          
BEGIN_PARTITION          
BETWEEN
BIGINT      
BINARY    
BIT        
BIT_LENGTH          
BLOB    
BOOLEAN    
BOTH
BREADTH          
BY
CALL
CALLED    
CARDINALITY        
CASCADE  
CASCADED  
CASE
CAST
CATALOG        
CEIL        
CEILING        
CHAR  
CHAR_LENGTH      
CHARACTER  
CHARACTER_LENGTH      
CHECK
CLOB    
CLOSE
COALESCE      
COLLATE
COLLATION        
COLLECT        
COLUMN
COMMIT
CONDITION
CONNECT
CONNECTION        
CONSTRAINT
CONSTRAINTS        
CONSTRUCTOR          
CONTAINS          
CONTINUE        
CONVERT      
CORR        
CORRESPONDING
COUNT      
COVAR_POP        
COVAR_SAMP        
CREATE
CROSS
CUBE    
CUME_DIST        
CURRENT
CURRENT_CATALOG        
CURRENT_DATE
CURRENT_DEFAULT_TRANSFORM_GROUP    
CURRENT_PATH
CURRENT_ROLE    
CURRENT_ROW          
CURRENT_SCHEMA        
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TRANSFORM_GROUP_FOR_TYPE    
CURRENT_USER
CURSOR
CYCLE    
DATA          
DATE  
DAY
DEALLOCATE
DEC  
DECIMAL  
DECLARE
DEFAULT
DEFERRABLE        
DEFERRED        
DELETE
DENSE_RANK        
DEPTH          
DEREF    
DESC        
DESCRIBE
DESCRIPTOR        
DETERMINISTIC
DIAGNOSTICS        
DISCONNECT
DISTINCT
DO
DOMAIN        
DOUBLE  
DROP
DYNAMIC    
EACH    
ELEMENT      
ELSE
ELSEIF
END
END_FRAME          
END_PARTITION          
END_EXEC        
EQUALS          
ESCAPE
EVERY        
EXCEPT
EXCEPTION        
EXEC  
EXECUTE
EXISTS
EXIT      
EXTERNAL
EXTRACT      
FALSE
FETCH
FILTER    
FIRST      
FIRST_VALUE          
FLOAT  
FOR
FOREIGN
FOUND        
FRAME_ROW          
FREE    
FROM
FULL
FUNCTION
FUSION      
GENERAL          
GET
GLOBAL
GO        
GOTO        
GRANT
GROUP
GROUPING    
GROUPS          
HANDLER
HAVING
HOLD  
HOUR
IDENTITY
IF
IMMEDIATE      
IN
INDICATOR
INITIALLY        
INNER
INOUT
INPUT      
INSENSITIVE  
INSERT
INT  
INTEGER  
INTERSECT
INTERSECTION        
INTERVAL
INTO
IS
ISOLATION        
ITERATE  
JOIN
KEY        
LANGUAGE
LARGE  
LAST        
LAST_VALUE          
LATERAL    
LEAD          
LEADING
LEAVE
LEFT
LEVEL        
LIKE
LIKE_REGEX        
LIMIT          
LN        
LOCAL
LOCALTIME  
LOCALTIMESTAMP  
LOCATOR          
LOOP
LOWER      
MAP          
MATCH
MAX      
MEMBER    
MERGE      
METHOD  
MIN      
MINUTE
MOD        
MODIFIES  
MODULE
MONTH
MULTISET      
NAMES        
NATIONAL
NATURAL
NCHAR  
NCLOB    
NEW  
NEXT      
NO
NONE    
NORMALIZE        
NOT
NTH_VALUE          
NTILE          
NULL
NULLIF      
NUMERIC  
OBJECT          
OCTET_LENGTH      
OF
OFFSET        
OLD  
ON
ONLY  
OPEN
OPTION        
OR
ORDER
ORDINALITY          
OUT
OUTER  
OUTPUT      
OVER        
OVERLAPS
OVERLAY        
PAD        
PARAMETER
PARTIAL        
PARTITION    
PATH        
PERCENT          
PERCENT_RANK        
PERCENTILE_CONT        
PERCENTILE_DISC        
PERIOD          
PORTION          
POSITION      
POSITION_REGEX        
POWER        
PRECEDES          
PRECISION
PREPARE
PRESERVE        
PRIMARY
PRIOR        
PRIVILEGES        
PROCEDURE
PUBLIC        
RANGE    
RANK        
READ        
READS  
REAL  
RECURSIVE    
REF    
REFERENCES
REFERENCING  
REGR_AVGX        
REGR_AVGY        
REGR_COUNT        
REGR_INTERCEPT        
REGR_R2        
REGR_SLOPE        
REGR_SXX        
REGR_SXYREGR_SYY        
RELATIVE        
RELEASE  
REPEAT
RESIGNAL
RESTRICT        
RESULT  
RETURN
RETURNS
REVOKE
RIGHT
ROLE          
ROLLBACK
ROLLUP    
ROUTINE        
ROW  
ROW_NUMBER        
ROWS
SAVEPOINT    
SCHEMA        
SCOPE    
SCROLL
SEARCH    
SECOND
SECTION        
SELECT
SENSITIVE    
SESSION        
SESSION_USER
SET
SETS          
SIGNAL  
SIMILAR    
SIZE        
SMALLINT  
SOME
SPACE        
SPECIFIC
SPECIFICTYPE    
SQL
SQLCODE          
SQLERROR          
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT        
START  
STATE          
STATIC  
STDDEV_POP        
STDDEV_SAMP        
SUBMULTISET      
SUBSTRING      
SUBSTRING_REGEX        
SUCCEEDS          
SUM      
SYMMETRIC  
SYSTEM    
SYSTEM_TIME          
SYSTEM_USER
TABLE
TABLESAMPLE      
TEMPORARY        
THEN
TIME  
TIMESTAMP  
TIMEZONE_HOUR
TIMEZONE_MINUTE
TO
TRAILING
TRANSACTION        
TRANSLATE      
TRANSLATE_REGEX        
TRANSLATION  
TREAT    
TRIGGER  
TRIM      
TRIM_ARRAY          
TRUE
TRUNCATE        
UESCAPE        
UNDER          
UNDO  
UNION
UNIQUE
UNKNOWN
UNNEST    
UNTIL  
UPDATE
UPPER      
USAGE        
USER
USING
VALUE
VALUES
VALUE_OF          
VAR_POP        
VAR_SAMP        
VARBINARY        
VARCHAR  
VARYING
VERSIONING          
VIEW        
WHEN
WHENEVER  
WHERE
WHILE
WIDTH_BUCKET        
WINDOW    
WITH
WITHIN    
WITHOUT  
WORK        
WRITE        
YEAR
ZONE        

 

Powered by Mimer SQL

Powered by Mimer SQL