HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

Keywords(1)

The SQL contains reserved and non-reserved words. Standards require that reserved keywords not be used as other identifiers. Non-reserved keywords have special meanings only in a specific environment and can be used as identifiers in other environments.

The naming rules for identifiers are as follows:

  • An identifier name can only contain letters, underscores, digits (0-9), and dollar signs ($).

  • An identifier name must start with a letter (a to z) or an underscore (_).

    img NOTE:

    • The naming rules are recommended but not mandatory.
    • In special cases, double quotation marks can be used to avoid special character errors.

Table 1 SQL keywords

Keyword MogDB
ABORT Non-reserved
ABS N/A
ABSOLUTE Non-reserved
ACCESS Non-reserved
ACCOUNT Non-reserved
ACTION Non-reserved
ADA N/A
ADD Non-reserved
ADMIN Non-reserved
AFTER Non-reserved
AGGREGATE Non-reserved
ALGORITHM Non-reserved
ALIAS N/A
ALL Reserved
ALLOCATE N/A
ALSO Non-reserved
ALTER Non-reserved
ALWAYS Non-reserved
ANALYSE Reserved
ANALYZE Reserved
AND Reserved
ANY Reserved
APP Non-reserved
ARE N/A
ARRAY Reserved
AS Reserved
ASC Reserved
ASENSITIVE N/A
ASSERTION Non-reserved
ASSIGNMENT Non-reserved
ASYMMETRIC Reserved
AT Non-reserved
ATOMIC N/A
ATTRIBUTE Non-reserved
AUTHID Reserved
AUTHORIZATION Reserved (functions and types allowed)
AUTOEXTEND Non-reserved
AUTOMAPPED Non-reserved
AVG N/A
BACKWARD Non-reserved
BARRIER Non-reserved
BEFORE Non-reserved
BEGIN Non-reserved
BEGIN_NON_ANOYBLOCK Non-reserved
BETWEEN Non-reserved (excluding functions and types)
BIGINT Non-reserved (excluding functions and types)
BINARY Reserved (functions and types allowed)
BINARY_DOUBLE Non-reserved (excluding functions and types)
BINARY_INTEGER Non-reserved (excluding functions and types)
BIT Non-reserved (excluding functions and types)
BITVAR N/A
BIT_LENGTH N/A
BLOB Non-reserved
BOOLEAN Non-reserved (excluding functions and types)
BOTH Reserved
BUCKETS Reserved
BREADTH N/A
BY Non-reserved
BYTEAWITHOUTODER Non-reserved (excluding functions and types)
BYTEAWITHOUTORDERWITHEQUAL Non-reserved (excluding functions and types)
C N/A
CACHE Non-reserved
CALL Non-reserved
CALLED Non-reserved
CARDINALITY N/A
CASCADE Non-reserved
CASCADED Non-reserved
CASE Reserved
CAST Reserved
CATALOG Non-reserved
CATALOG_NAME N/A
CHAIN Non-reserved
CHAR Non-reserved (excluding functions and types)
CHARACTER Non-reserved (excluding functions and types)
CHARACTERISTICS Non-reserved
CHARACTER_LENGTH N/A
CHARACTER_SET_CATALOG N/A
CHARACTER_SET_NAME N/A
CHARACTER_SET_SCHEMA N/A
CHAR_LENGTH N/A
CHECK Reserved
CHECKED N/A
CHECKPOINT Non-reserved
CLASS Non-reserved
CLEAN Non-reserved
CLASS_ORIGIN N/A
CLIENT Non-reserved
CLIENT_MASTER_KEY Non-reserved
CLIENT_MASTER_KEYS Non-reserved
CLOB Non-reserved
CLOSE Non-reserved
CLUSTER Non-reserved
COALESCE Non-reserved (excluding functions and types)
COBOL N/A
COLLATE Reserved
COLLATION Reserved (functions and types allowed)
COLLATION_CATALOG N/A
COLLATION_NAME N/A
COLLATION_SCHEMA N/A
COLUMN Reserved
COLUMN_ENCRYPTION_KEY Non-reserved
COLUMN_ENCRYPTION_KEYS Non-reserved
COLUMN_NAME N/A
COMPACT Reserved (functions and types allowed)
COMPATIBLE_ILLEGAL_CHARS Non-reserved
COMMAND_FUNCTION N/A
COMPLETE Non-reserved
COMMAND_FUNCTION_CODE N/A
COMMENT Non-reserved
COMMENTS Non-reserved
COMMIT Non-reserved
COMMITTED Non-reserved
COMPRESS Non-reserved
COMPLETION N/A
CONCURRENTLY Reserved (functions and types allowed)
CONDITION N/A
CONDITION_NUMBER N/A
CONFIGURATION Non-reserved
CONNECT N/A
CONNECTION Non-reserved
CONNECTION_NAME N/A
CONSTRAINT Reserved
CONSTRAINTS Non-reserved
CONSTRAINT_CATALOG N/A
CONSTRAINT_NAME N/A
CONSTRAINT_SCHEMA N/A
CONSTRUCTOR N/A
CONTAINS N/A
CONTENT Non-reserved
CONTINUE Non-reserved
CONVERSION Non-reserved
CONVERT N/A
COPY Non-reserved
CORRESPONDING N/A
COST Non-reserved
COUNT N/A
CREATE Reserved
CROSS Reserved (functions and types allowed)
CSV Non-reserved
CUBE Non-reserved
CURRENT Non-reserved
CURRENT_CATALOG Reserved
CURRENT_DATE Reserved
CURRENT_PATH N/A
CURRENT_ROLE Reserved
CURRENT_SCHEMA Reserved (functions and types allowed)
CURRENT_TIME Reserved
CURRENT_TIMESTAMP Reserved
CURRENT_USER Reserved
CURSOR Non-reserved
CURSOR_NAME N/A
CYCLE Non-reserved
DATA Non-reserved
DATABASE Non-reserved
DATAFILE Non-reserved
DATE_FORMAT Non-reserved
DATATYPE_CL Non-reserved
DATE Non-reserved (excluding functions and types)
DELTAMERGE Reserved (functions and types allowed)
DATETIME_INTERVAL_CODE N/A
DATETIME_INTERVAL_PRECISION N/A
DAY Non-reserved
DBCOMPATIBILITY Non-reserved
DEALLOCATE Non-reserved
DEC Non-reserved (excluding functions and types)
DECIMAL Non-reserved (excluding functions and types)
DECLARE Non-reserved
DECODE Non-reserved (excluding functions and types)
DEFAULT Reserved
DEFAULTS Non-reserved
DEFERRABLE Reserved
DEFERRED Non-reserved
DEFINED N/A
DEFINER Non-reserved
DELETE Non-reserved
DELIMITER Non-reserved
DELIMITERS Non-reserved
DELTA Non-reserved
DEPTH N/A
DEREF N/A
DESC Reserved
DESCRIBE N/A
DESCRIPTOR N/A
DESTROY N/A
DESTRUCTOR N/A
DETERMINISTIC Non-reserved
DIAGNOSTICS N/A
DICTIONARY Non-reserved
DIRECT Non-reserved
DIRECTORY Non-reserved
DISABLE Non-reserved
DISCARD Non-reserved
DISCONNECT Non-reserved
DISPATCH N/A
DISTINCT Reserved
DISTRIBUTE Non-reserved
DISTRIBUTION Non-reserved
DO Reserved
DOCUMENT Non-reserved
DOMAIN Non-reserved
DOUBLE Non-reserved
DROP Non-reserved
DUPLICATE Non-reserved
DYNAMIC N/A
DYNAMIC_FUNCTION N/A
DYNAMIC_FUNCTION_CODE N/A
EACH Non-reserved
ELSE Reserved
ELASTIC Non-reserved
ENABLE Non-reserved
ENCODING Non-reserved
ENCRYPTED Non-reserved
ENCRYPTED_VALUE Non-reserved
ENCRYPTION Non-reserved
ENCRYPTION_TYPE Non-reserved
END Reserved
END-EXEC N/A
ENFORCED Non-reserved
ENUM Non-reserved
EOL Non-reserved
ERRORS Non-reserved
EQUALS N/A
ESCAPE Non-reserved
ESCAPING Non-reserved
EVERY Non-reserved
EXCEPT Reserved
EXCEPTION N/A
EXCHANGE Non-reserved
EXCLUDE Non-reserved
EXCLUDED Reserved
EXCLUDING Non-reserved
EXCLUSIVE Non-reserved
EXEC N/A
EXECUTE Non-reserved
EXISTING N/A
EXISTS Non-reserved (excluding functions and types)
EXPIRED_P Non-reserved
EXPLAIN Non-reserved
EXTENSION Non-reserved
EXTERNAL Non-reserved
EXTRACT Non-reserved (excluding functions and types)
FALSE Reserved
FAMILY Non-reserved
FAST Non-reserved
FETCH Reserved
FENCED Reserved
FILEHEADER Non-reserved
FINAL N/A
FIRST Non-reserved
FIXED Non-reserved
FILL_MISSING_FIELDS Non-reserved
FLOAT Non-reserved (excluding functions and types)
FOLLOWING Non-reserved
FOR Reserved
FORCE Non-reserved
FOREIGN Reserved
FORMATTER Non-reserved
FORTRAN N/A
FORWARD Non-reserved
FOUND N/A
FREE N/A
FREEZE Reserved (functions and types allowed)
FROM Reserved
FULL Reserved (functions and types allowed)
FUNCTION Non-reserved
FUNCTIONS Non-reserved
G N/A
GENERAL N/A
GENERATED N/A
GET N/A
GLOBAL Non-reserved
GO N/A
GOTO N/A
GRANT Reserved
GRANTED Non-reserved
GREATEST Non-reserved (excluding functions and types)
GROUP Reserved
GROUPING Non-reserved (excluding functions and types)
HANDLER Non-reserved
HAVING Reserved
HDFSDIRECTORY Reserved (functions and types allowed)
HEADER Non-reserved
HIERARCHY N/A
HOLD Non-reserved
HOST N/A
HOUR Non-reserved
IDENTIFIED Non-reserved
IDENTITY Non-reserved
IF Non-reserved
IGNORE N/A
IGNORE_EXTRA_DATA Non-reserved
ILIKE Reserved (functions and types allowed)
IMMEDIATE Non-reserved
IMMUTABLE Non-reserved
IMPLEMENTATION N/A
IMPLICIT Non-reserved
IN Reserved
INTERNAL Non-reserved
INCLUDING Non-reserved
INCREMENT Non-reserved
INDEX Non-reserved
INDEXES Non-reserved
INDICATOR N/A
INFIX N/A
INHERIT Non-reserved
INHERITS Non-reserved
INITIAL Non-reserved
INITIALIZE N/A
INITIALLY Reserved
INITRANS Non-reserved
INLINE Non-reserved
INNER Reserved (functions and types allowed)
INOUT Non-reserved (excluding functions and types)
INPUT Non-reserved
INSENSITIVE Non-reserved
INSERT Non-reserved
INSTANCE N/A
INSTANTIABLE N/A
INSTEAD Non-reserved
INT Non-reserved (excluding functions and types)
INTEGER Non-reserved (excluding functions and types)
INTERSECT Reserved
INTERVAL Non-reserved (excluding functions and types)
INTO Reserved
INVOKER Non-reserved
IS Reserved
ISNULL Non-reserved
ISOLATION Non-reserved
ITERATE N/A
JOIN Reserved (functions and types allowed)
K N/A
KEY Non-reserved
KEY_PATH Non-reserved
KEY_MEMBER N/A
KEY_STORE Non-reserved
KEY_TYPE N/A
KILL Non-reserved
LABEL Non-reserved
LANGUAGE Non-reserved
LARGE Non-reserved
LAST Non-reserved
LATERAL N/A
LC_COLLATE Non-reserved
LC_CTYPE Non-reserved
LEADING Reserved
LEAKPROOF Non-reserved
LEAST Non-reserved (excluding functions and types)
LEFT Reserved (functions and types allowed)
LENGTH N/A
LESS Reserved
LEVEL Non-reserved
LIKE Reserved (functions and types allowed)
LIMIT Reserved
LISTEN Non-reserved
LOAD Non-reserved
Copyright © 2011-2024 www.enmotech.com All rights reserved.