Keyword
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.
Keyword |
GaussDB(DWS) |
SQL:1999 |
SQL-92 |
---|---|---|---|
ABORT |
Non-reserved |
- |
- |
ABS |
- |
Non-reserved |
- |
ABSOLUTE |
Non-reserved |
Reserved |
Reserved |
ACCESS |
Non-reserved |
- |
- |
ACCOUNT |
Non-reserved |
- |
- |
ACTION |
Non-reserved |
Reserved |
Reserved |
ADA |
- |
Non-reserved |
Non-reserved |
ADD |
Non-reserved |
Reserved |
Reserved |
ADMIN |
Non-reserved |
Reserved |
- |
AFTER |
Non-reserved |
Reserved |
- |
AGGREGATE |
Non-reserved |
Reserved |
- |
ALIAS |
- |
Reserved |
- |
ALL |
Reserved |
Reserved |
Reserved |
ALLOCATE |
- |
Reserved |
Reserved |
ALSO |
Non-reserved |
- |
- |
ALTER |
Non-reserved |
Reserved |
Reserved |
ALWAYS |
Non-reserved |
- |
- |
ANALYSE |
Reserved |
- |
- |
ANALYZE |
Reserved |
- |
- |
AND |
Reserved |
Reserved |
Reserved |
ANY |
Reserved |
Reserved |
Reserved |
APP |
Non-reserved |
- |
- |
ARE |
- |
Reserved |
Reserved |
ARRAY |
Reserved |
Reserved |
- |
AS |
Reserved |
Reserved |
Reserved |
ASC |
Reserved |
Reserved |
Reserved |
ASENSITIVE |
- |
Non-reserved |
- |
ASSERTION |
Non-reserved |
Reserved |
Reserved |
ASSIGNMENT |
Non-reserved |
Non-reserved |
- |
ASYMMETRIC |
Reserved |
Non-reserved |
- |
AT |
Non-reserved |
Reserved |
Reserved |
ATOMIC |
- |
Non-reserved |
- |
ATTRIBUTE |
Non-reserved |
- |
- |
AUTHID |
Reserved |
- |
- |
AUTHINFO |
Non-reserved |
- |
- |
AUTHORIZATION |
Reserved (functions and types allowed) |
Reserved |
Reserved |
AUTOEXTEND |
Non-reserved |
- |
- |
AUTOMAPPED |
Non-reserved |
- |
- |
AVG |
- |
Non-reserved |
Reserved |
BACKWARD |
Non-reserved |
- |
- |
BARRIER |
Non-reserved |
- |
- |
BEFORE |
Non-reserved |
Reserved |
- |
BEGIN |
Non-reserved |
Reserved |
Reserved |
BETWEEN |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
BIGINT |
Non-reserved (excluding functions and types) |
- |
- |
BINARY |
Reserved (functions and types allowed) |
Reserved |
- |
BINARY_DOUBLE |
Non-reserved (excluding functions and types) |
- |
- |
BINARY_INTEGER |
Non-reserved (excluding functions and types) |
- |
- |
BIT |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
BITVAR |
- |
Non-reserved |
- |
BIT_LENGTH |
- |
Non-reserved |
Reserved |
BLOB |
Non-reserved |
Reserved |
- |
BOOLEAN |
Non-reserved (excluding functions and types) |
Reserved |
- |
BOTH |
Reserved |
Reserved |
Reserved |
BUCKETS |
Reserved |
- |
- |
BREADTH |
- |
Reserved |
- |
BY |
Non-reserved |
Reserved |
Reserved |
C |
- |
Non-reserved |
Non-reserved |
CACHE |
Non-reserved |
- |
- |
CALL |
Non-reserved |
Reserved |
- |
CALLED |
Non-reserved |
Non-reserved |
- |
CARDINALITY |
- |
Non-reserved |
- |
CASCADE |
Non-reserved |
Reserved |
Reserved |
CASCADED |
Non-reserved |
Reserved |
Reserved |
CASE |
Reserved |
Reserved |
Reserved |
CAST |
Reserved |
Reserved |
Reserved |
CATALOG |
Non-reserved |
Reserved |
Reserved |
CATALOG_NAME |
- |
Non-reserved |
Non-reserved |
CHAIN |
Non-reserved |
Non-reserved |
- |
CHAR |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
CHARACTER |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
CHARACTERISTICS |
Non-reserved |
- |
- |
CHARACTER_LENGTH |
- |
Non-reserved |
Reserved |
CHARACTER_SET_CATALOG |
- |
Non-reserved |
Non-reserved |
CHARACTER_SET_NAME |
- |
Non-reserved |
Non-reserved |
CHARACTER_SET_SCHEMA |
- |
Non-reserved |
Non-reserved |
CHAR_LENGTH |
- |
Non-reserved |
Reserved |
CHECK |
Reserved |
Reserved |
Reserved |
CHECKED |
- |
Non-reserved |
- |
CHECKPOINT |
Non-reserved |
- |
- |
CLASS |
Non-reserved |
Reserved |
- |
CLEAN |
Non-reserved |
- |
- |
CLASS_ORIGIN |
- |
Non-reserved |
Non-reserved |
CLOB |
Non-reserved |
Reserved |
- |
CLOSE |
Non-reserved |
Reserved |
Reserved |
CLUSTER |
Non-reserved |
- |
- |
COALESCE |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
COBOL |
- |
Non-reserved |
Non-reserved |
COLLATE |
Reserved |
Reserved |
Reserved |
COLLATION |
Reserved (functions and types allowed) |
Reserved |
Reserved |
COLLATION_CATALOG |
- |
Non-reserved |
Non-reserved |
COLLATION_NAME |
- |
Non-reserved |
Non-reserved |
COLLATION_SCHEMA |
- |
Non-reserved |
Non-reserved |
COLUMN |
Reserved |
Reserved |
Reserved |
COLUMNS |
Non-reserved |
- |
- |
COLUMN_NAME |
- |
Non-reserved |
Non-reserved |
COMMAND_FUNCTION |
- |
Non-reserved |
Non-reserved |
COMMAND_FUNCTION_CODE |
- |
Non-reserved |
- |
COMMENT |
Non-reserved |
- |
- |
COMMENTS |
Non-reserved |
- |
- |
COMMIT |
Non-reserved |
Reserved |
Reserved |
COMMITTED |
Non-reserved |
Non-reserved |
Non-reserved |
COMPATIBLE_ILLEGAL_CHARS |
Non-reserved |
- |
- |
COMPLETE |
Non-reserved |
- |
- |
COMPRESS |
Non-reserved |
- |
- |
COMPLETION |
- |
Reserved |
- |
CONCURRENTLY |
Reserved (functions and types allowed) |
- |
- |
CONDITION |
- |
- |
- |
CONDITION_NUMBER |
- |
Non-reserved |
Non-reserved |
CONFIGURATION |
Non-reserved |
- |
- |
CONNECT |
- |
Reserved |
Reserved |
CONNECTION |
Non-reserved |
Reserved |
Reserved |
CONNECTION_NAME |
- |
Non-reserved |
Non-reserved |
CONSTRAINT |
Reserved |
Reserved |
Reserved |
CONSTRAINTS |
Non-reserved |
Reserved |
Reserved |
CONSTRAINT_CATALOG |
- |
Non-reserved |
Non-reserved |
CONSTRAINT_NAME |
- |
Non-reserved |
Non-reserved |
CONSTRAINT_SCHEMA |
- |
Non-reserved |
Non-reserved |
CONSTRUCTOR |
- |
Reserved |
- |
CONTAINS |
- |
Non-reserved |
- |
CONTENT |
Non-reserved |
- |
- |
CONTINUE |
Non-reserved |
Reserved |
Reserved |
CONVERSION |
Non-reserved |
- |
- |
CONVERT |
- |
Non-reserved |
Reserved |
COORDINATOR |
Non-reserved |
- |
- |
COPY |
Non-reserved |
- |
- |
CORRESPONDING |
- |
Reserved |
Reserved |
COST |
Non-reserved |
- |
- |
COUNT |
- |
Non-reserved |
Reserved |
CREATE |
Reserved |
Reserved |
Reserved |
CROSS |
Reserved (functions and types allowed) |
Reserved |
Reserved |
CSV |
Non-reserved |
- |
- |
CUBE |
- |
Reserved |
- |
CURRENT |
Non-reserved |
Reserved |
Reserved |
CURRENT_CATALOG |
Reserved |
- |
- |
CURRENT_DATE |
Reserved |
Reserved |
Reserved |
CURRENT_PATH |
- |
Reserved |
- |
CURRENT_ROLE |
Reserved |
Reserved |
- |
CURRENT_SCHEMA |
Reserved (functions and types allowed) |
- |
- |
CURRENT_TIME |
Reserved |
Reserved |
Reserved |
CURRENT_TIMESTAMP |
Reserved |
Reserved |
Reserved |
CURRENT_USER |
Reserved |
Reserved |
Reserved |
CURSOR |
Non-reserved |
Reserved |
Reserved |
CURSOR_NAME |
- |
Non-reserved |
Non-reserved |
CYCLE |
Non-reserved |
Reserved |
- |
DATA |
Non-reserved |
Reserved |
Non-reserved |
DATE_FORMAT |
Non-reserved |
- |
- |
DATABASE |
Non-reserved |
- |
- |
DATAFILE |
Non-reserved |
- |
- |
DATE |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
DATETIME_INTERVAL_CODE |
- |
Non-reserved |
Non-reserved |
DATETIME_INTERVAL_PRECISION |
- |
Non-reserved |
Non-reserved |
DAY |
Non-reserved |
Reserved |
Reserved |
DBCOMPATIBILITY |
Non-reserved |
- |
- |
DEALLOCATE |
Non-reserved |
Reserved |
Reserved |
DEC |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
DECIMAL |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
DECLARE |
Non-reserved |
Reserved |
Reserved |
DECODE |
Non-reserved (excluding functions and types) |
- |
- |
DEFAULT |
Reserved |
Reserved |
Reserved |
DEFAULTS |
Non-reserved |
- |
- |
DEFERRABLE |
Reserved |
Reserved |
Reserved |
DEFERRED |
Non-reserved |
Reserved |
Reserved |
DEFINED |
- |
Non-reserved |
- |
DEFINER |
Non-reserved |
Non-reserved |
- |
DELETE |
Non-reserved |
Reserved |
Reserved |
DELIMITER |
Non-reserved |
- |
- |
DELIMITERS |
Non-reserved |
- |
- |
DELTA |
Non-reserved |
- |
- |
DEPTH |
- |
Reserved |
- |
DEREF |
- |
Reserved |
- |
DESC |
Reserved |
Reserved |
Reserved |
DESCRIBE |
- |
Reserved |
Reserved |
DESCRIPTOR |
- |
Reserved |
Reserved |
DESTROY |
- |
Reserved |
- |
DESTRUCTOR |
- |
Reserved |
- |
DETERMINISTIC |
Non-reserved |
Reserved |
- |
DIAGNOSTICS |
- |
Reserved |
Reserved |
DICTIONARY |
Non-reserved |
Reserved |
- |
DIRECT |
Non-reserved |
- |
- |
DIRECTORY |
Non-reserved |
- |
- |
DISABLE |
Non-reserved |
- |
- |
DISCARD |
Non-reserved |
- |
- |
DISCONNECT |
- |
Reserved |
Reserved |
DISPATCH |
- |
Non-reserved |
- |
DISTINCT |
Reserved |
Reserved |
Reserved |
DISTRIBUTE |
Non-reserved |
- |
- |
DISTRIBUTION |
Non-reserved |
- |
- |
DO |
Reserved |
- |
- |
DOCUMENT |
Non-reserved |
- |
- |
DOMAIN |
Non-reserved |
Reserved |
Reserved |
DOUBLE |
Non-reserved |
Reserved |
Reserved |
DROP |
Non-reserved |
Reserved |
Reserved |
DYNAMIC |
- |
Reserved |
- |
DYNAMIC_FUNCTION |
- |
Non-reserved |
Non-reserved |
DYNAMIC_FUNCTION_CODE |
- |
Non-reserved |
- |
EACH |
Non-reserved |
Reserved |
- |
ELASTIC |
Non-reserved |
- |
- |
ELSE |
Reserved |
Reserved |
Reserved |
ENABLE |
Non-reserved |
- |
- |
ENCODING |
Non-reserved |
- |
- |
ENCRYPTED |
Non-reserved |
- |
- |
END |
Reserved |
Reserved |
Reserved |
END-EXEC |
- |
Reserved |
Reserved |
ENFORCED |
Non-reserved |
- |
- |
ENUM |
Non-reserved |
- |
- |
EOL |
Non-reserved |
- |
- |
EQUALS |
- |
Reserved |
- |
ERRORS |
Non-reserved |
- |
- |
ESCAPE |
Non-reserved |
Reserved |
Reserved |
ESCAPING |
Non-reserved |
- |
- |
EVERY |
Non-reserved |
Reserved |
- |
EXCEPT |
Reserved |
Reserved |
Reserved |
EXCEPTION |
- |
Reserved |
Reserved |
EXCHANGE |
Non-reserved |
- |
- |
EXCLUDE |
Non-reserved |
- |
- |
EXCLUDING |
Non-reserved |
- |
- |
EXCLUSIVE |
Non-reserved |
- |
- |
EXEC |
- |
Reserved |
Reserved |
EXECUTE |
Non-reserved |
Reserved |
Reserved |
EXISTING |
- |
Non-reserved |
- |
EXISTS |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
EXPIRATION |
Non-reserved |
- |
- |
EXPLAIN |
Non-reserved |
- |
- |
EXTENSION |
Non-reserved |
- |
- |
EXTERNAL |
Non-reserved |
Reserved |
Reserved |
EXTRACT |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
FALSE |
Reserved |
Reserved |
Reserved |
FAMILY |
Non-reserved |
- |
- |
FAST |
Non-reserved |
- |
- |
FENCED |
Non-reserved |
- |
- |
FETCH |
Reserved |
Reserved |
Reserved |
FILEHEADER |
Non-reserved |
- |
- |
FILL_MISSING_FIELDS |
Non-reserved |
- |
- |
FINAL |
- |
Non-reserved |
- |
FIRST |
Non-reserved |
Reserved |
Reserved |
FIXED |
Non-reserved |
Reserved |
Reserved |
FLOAT |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
FOLLOWING |
Non-reserved |
- |
- |
FOR |
Reserved |
Reserved |
Reserved |
FORCE |
Non-reserved |
- |
- |
FOREIGN |
Reserved |
Reserved |
Reserved |
FORMATTER |
Non-reserved |
- |
- |
FORTRAN |
- |
Non-reserved |
Non-reserved |
FORWARD |
Non-reserved |
- |
- |
FOUND |
- |
Reserved |
Reserved |
FREE |
- |
Reserved |
- |
FREEZE |
Reserved (functions and types allowed) |
- |
- |
FROM |
Reserved |
Reserved |
Reserved |
FULL |
Reserved (functions and types allowed) |
Reserved |
Reserved |
FUNCTION |
Non-reserved |
Reserved |
- |
FUNCTIONS |
Non-reserved |
- |
- |
G |
- |
Non-reserved |
- |
GENERAL |
- |
Reserved |
- |
GENERATED |
- |
Non-reserved |
- |
GET |
- |
Reserved |
Reserved |
GLOBAL |
Non-reserved |
Reserved |
Reserved |
GO |
- |
Reserved |
Reserved |
GOTO |
- |
Reserved |
Reserved |
GRANT |
Reserved |
Reserved |
Reserved |
GRANTED |
Non-reserved |
Non-reserved |
- |
GREATEST |
Non-reserved (excluding functions and types) |
- |
- |
GROUP |
Reserved |
Reserved |
Reserved |
GROUPING |
- |
Reserved |
- |
HANDLER |
Non-reserved |
- |
- |
HAVING |
Reserved |
Reserved |
Reserved |
HEADER |
Non-reserved |
- |
- |
HIERARCHY |
- |
Non-reserved |
- |
HOLD |
Non-reserved |
Non-reserved |
- |
HOST |
- |
Reserved |
- |
HOUR |
Non-reserved |
Reserved |
Reserved |
IDENTIFIED |
Non-reserved |
- |
- |
IDENTITY |
Non-reserved |
Reserved |
Reserved |
IF |
Non-reserved (excluding functions and types) |
- |
- |
IFNULL |
Non-reserved (excluding functions and types) |
- |
- |
IGNORE |
- |
Reserved |
- |
IGNORE_EXTRA_DATA |
Non-reserved |
- |
- |
ILIKE |
Reserved (functions and types allowed) |
- |
- |
IMMEDIATE |
Non-reserved |
Reserved |
Reserved |
IMMUTABLE |
Non-reserved |
- |
- |
IMPLEMENTATION |
- |
Non-reserved |
- |
IMPLICIT |
Non-reserved |
- |
- |
IN |
Reserved |
Reserved |
Reserved |
INCLUDING |
Non-reserved |
- |
- |
INCREMENT |
Non-reserved |
- |
- |
INDEX |
Non-reserved |
- |
- |
INDEXES |
Non-reserved |
- |
- |
INDICATOR |
- |
Reserved |
Reserved |
INFIX |
- |
Non-reserved |
- |
INHERIT |
Non-reserved |
- |
- |
INHERITS |
Non-reserved |
- |
- |
INITIAL |
Non-reserved |
- |
- |
INITIALIZE |
- |
Reserved |
- |
INITIALLY |
Reserved |
Reserved |
Reserved |
INITRANS |
Non-reserved |
- |
- |
INLINE |
Non-reserved |
- |
- |
INNER |
Reserved (functions and types allowed) |
Reserved |
Reserved |
INOUT |
Non-reserved (excluding functions and types) |
Reserved |
- |
INPUT |
Non-reserved |
Reserved |
Reserved |
INSENSITIVE |
Non-reserved |
Non-reserved |
Reserved |
INSERT |
Non-reserved |
Reserved |
Reserved |
INSTANCE |
- |
Non-reserved |
- |
INSTANTIABLE |
- |
Non-reserved |
- |
INSTEAD |
Non-reserved |
- |
- |
INT |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
INTEGER |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
INTERNAL |
Reserved |
- |
- |
INTERSECT |
Reserved |
Reserved |
Reserved |
INTERVAL |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
INTO |
Reserved |
Reserved |
Reserved |
INVOKER |
Non-reserved |
Non-reserved |
- |
IS |
Reserved |
Reserved |
Reserved |
ISNULL |
Non-reserved (excluding functions and types) |
- |
- |
ISOLATION |
Non-reserved |
Reserved |
Reserved |
ITERATE |
- |
Reserved |
- |
JOIN |
Reserved (functions and types allowed) |
Reserved |
Reserved |
K |
- |
Non-reserved |
- |
KEY |
Non-reserved |
Reserved |
Reserved |
KEY_MEMBER |
- |
Non-reserved |
- |
KEY_TYPE |
- |
Non-reserved |
- |
LABEL |
Non-reserved |
- |
- |
LANGUAGE |
Non-reserved |
Reserved |
Reserved |
LARGE |
Non-reserved |
Reserved |
- |
LAST |
Non-reserved |
Reserved |
Reserved |
LATERAL |
- |
Reserved |
- |
LC_COLLATE |
Non-reserved |
- |
- |
LC_CTYPE |
Non-reserved |
- |
- |
LEADING |
Reserved |
Reserved |
Reserved |
LEAKPROOF |
Non-reserved |
- |
- |
LEAST |
Non-reserved (excluding functions and types) |
- |
- |
LEFT |
Reserved (functions and types allowed) |
Reserved |
Reserved |
LENGTH |
- |
Non-reserved |
Non-reserved |
LESS |
Reserved |
Reserved |
- |
LEVEL |
Non-reserved |
Reserved |
Reserved |
LIKE |
Reserved (functions and types allowed) |
Reserved |
Reserved |
LIMIT |
Reserved |
Reserved |
- |
LISTEN |
Non-reserved |
- |
- |
LOAD |
Non-reserved |
- |
- |
LOCAL |
Non-reserved |
Reserved |
Reserved |
LOCALTIME |
Reserved |
Reserved |
- |
LOCALTIMESTAMP |
Reserved |
Reserved |
- |
LOCATION |
Non-reserved |
- |
- |
LOCATOR |
- |
Reserved |
- |
LOCK |
Non-reserved |
- |
- |
LOG |
Non-reserved |
- |
- |
LOGGING |
Non-reserved |
- |
- |
LOGIN |
Non-reserved |
- |
- |
LOOP |
Non-reserved |
- |
- |
LOWER |
- |
Non-reserved |
Reserved |
M |
- |
Non-reserved |
- |
MAP |
- |
Reserved |
- |
MAPPING |
Non-reserved |
- |
- |
MATCH |
Non-reserved |
Reserved |
Reserved |
MATCHED |
Non-reserved |
- |
- |
MATERIALIZED |
Non-reserved |
- |
- |
MAX |
- |
Non-reserved |
Reserved |
MAXEXTENTS |
Non-reserved |
- |
- |
MAXSIZE |
Non-reserved |
- |
- |
MAXTRANS |
Non-reserved |
- |
- |
MAXVALUE |
Reserved |
- |
- |
MERGE |
Non-reserved |
- |
- |
MESSAGE_LENGTH |
- |
Non-reserved |
Non-reserved |
MESSAGE_OCTET_LENGTH |
- |
Non-reserved |
Non-reserved |
MESSAGE_TEXT |
- |
Non-reserved |
Non-reserved |
METHOD |
- |
Non-reserved |
- |
MIN |
- |
Non-reserved |
Reserved |
MINEXTENTS |
Non-reserved |
- |
- |
MINUS |
Reserved |
- |
- |
MINUTE |
Non-reserved |
Reserved |
Reserved |
MINVALUE |
Non-reserved |
- |
- |
MOD |
- |
Non-reserved |
- |
MODE |
Non-reserved |
- |
- |
MODIFIES |
- |
Reserved |
- |
MODIFY |
Reserved |
Reserved |
- |
MODULE |
- |
Reserved |
Reserved |
MONTH |
Non-reserved |
Reserved |
Reserved |
MORE |
- |
Non-reserved |
Non-reserved |
MOVE |
Non-reserved |
- |
- |
MOVEMENT |
Non-reserved |
- |
- |
MUMPS |
- |
Non-reserved |
Non-reserved |
NAME |
Non-reserved |
Non-reserved |
Non-reserved |
NAMES |
Non-reserved |
Reserved |
Reserved |
NATIONAL |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
NATURAL |
Reserved (functions and types allowed) |
Reserved |
Reserved |
NCHAR |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
NCLOB |
- |
Reserved |
- |
NEW |
- |
Reserved |
- |
NEXT |
Non-reserved |
Reserved |
Reserved |
NLSSORT |
Reserved |
- |
- |
NO |
Non-reserved |
Reserved |
Reserved |
NOCOMPRESS |
Non-reserved |
- |
- |
NOCYCLE |
Non-reserved |
- |
- |
NODE |
Non-reserved |
- |
- |
NOLOGGING |
Non-reserved |
- |
- |
NOLOGIN |
Non-reserved |
- |
- |
NOMAXVALUE |
Non-reserved |
- |
- |
NOMINVALUE |
Non-reserved |
- |
- |
NONE |
Non-reserved (excluding functions and types) |
Reserved |
- |
NOT |
Reserved |
Reserved |
Reserved |
NOTHING |
Non-reserved |
- |
- |
NOTIFY |
Non-reserved |
- |
- |
NOTNULL |
Reserved (functions and types allowed) |
- |
- |
NOWAIT |
Non-reserved |
- |
- |
NULL |
Reserved |
Reserved |
Reserved |
NULLABLE |
- |
Non-reserved |
Non-reserved |
NULLIF |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
NULLS |
Non-reserved |
- |
- |
NUMBER |
Non-reserved (excluding functions and types) |
Non-reserved |
Non-reserved |
NUMERIC |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
NUMSTR |
Non-reserved |
- |
- |
NVARCHAR2 |
Non-reserved (excluding functions and types) |
- |
- |
NVL |
Non-reserved (excluding functions and types) |
- |
- |
OBJECT |
Non-reserved |
Reserved |
- |
OCTET_LENGTH |
- |
Non-reserved |
Reserved |
OF |
Non-reserved |
Reserved |
Reserved |
OFF |
Non-reserved |
Reserved |
- |
OFFSET |
Reserved |
- |
- |
OIDS |
Non-reserved |
- |
- |
OLD |
- |
Reserved |
- |
ON |
Reserved |
Reserved |
Reserved |
ONLY |
Reserved |
Reserved |
Reserved |
OPEN |
- |
Reserved |
Reserved |
OPERATION |
- |
Reserved |
- |
OPERATOR |
Non-reserved |
- |
- |
OPTIMIZATION |
Non-reserved |
- |
- |
OPTION |
Non-reserved |
Reserved |
Reserved |
OPTIONS |
Non-reserved |
Non-reserved |
- |
OR |
Reserved |
Reserved |
Reserved |
ORDER |
Reserved |
Reserved |
Reserved |
ORDINALITY |
- |
Reserved |
- |
OUT |
Non-reserved (excluding functions and types) |
Reserved |
- |
OUTER |
Reserved (functions and types allowed) |
Reserved |
Reserved |
OUTPUT |
- |
Reserved |
Reserved |
OVER |
Non-reserved |
- |
- |
OVERLAPS |
Reserved (functions and types allowed) |
Non-reserved |
Reserved |
OVERLAY |
Non-reserved (excluding functions and types) |
Non-reserved |
- |
OVERRIDING |
- |
Non-reserved |
- |
OWNED |
Non-reserved |
- |
- |
OWNER |
Non-reserved |
- |
- |
PACKAGE |
Non-reserved |
- |
- |
PAD |
- |
Reserved |
Reserved |
PARAMETER |
- |
Reserved |
- |
PARAMETERS |
- |
Reserved |
- |
PARAMETER_MODE |
- |
Non-reserved |
- |
PARAMETER_NAME |
- |
Non-reserved |
- |
PARAMETER_ORDINAL_POSITION |
- |
Non-reserved |
- |
PARAMETER_SPECIFIC_CATALOG |
- |
Non-reserved |
- |
PARAMETER_SPECIFIC_NAME |
- |
Non-reserved |
- |
PARAMETER_SPECIFIC_SCHEMA |
- |
Non-reserved |
- |
PARSER |
Non-reserved |
- |
- |
PARTIAL |
Non-reserved |
Reserved |
Reserved |
PARTITION |
Non-reserved |
- |
- |
PARTITIONS |
Non-reserved |
- |
- |
PASCAL |
- |
Non-reserved |
Non-reserved |
PASSING |
Non-reserved |
- |
- |
PASSWORD |
Non-reserved |
- |
- |
PATH |
- |
Reserved |
- |
PCTFREE |
Non-reserved |
- |
- |
PER |
Non-reserved |
- |
- |
PERM |
Non-reserved |
- |
- |
PERCENT |
Non-reserved |
- |
- |
PERFORMANCE |
Reserved |
- |
- |
PLACING |
Reserved |
- |
- |
PLAN |
Reserved |
- |
- |
PLANS |
Non-reserved |
- |
- |
PLI |
- |
Non-reserved |
Non-reserved |
POLICY |
Non-reserved |
- |
- |
POOL |
Non-reserved |
- |
- |
POSITION |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
POSTFIX |
- |
Reserved |
- |
PRECEDING |
Non-reserved |
- |
- |
PRECISION |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
PREFERRED |
Non-reserved |
- |
- |
PREFIX |
Non-reserved |
Reserved |
- |
PREORDER |
- |
Reserved |
- |
PREPARE |
Non-reserved |
Reserved |
Reserved |
PREPARED |
Non-reserved |
- |
- |
PRESERVE |
Non-reserved |
Reserved |
Reserved |
PRIMARY |
Reserved |
Reserved |
Reserved |
PRIOR |
Non-reserved |
Reserved |
Reserved |
PRIVATE |
Non-reserved |
- |
- |
PRIVILEGE |
Non-reserved |
- |
- |
PRIVILEGES |
Non-reserved |
Reserved |
Reserved |
PROCEDURAL |
Non-reserved |
- |
- |
PROCEDURE |
Reserved |
Reserved |
Reserved |
PROFILE |
Non-reserved |
- |
- |
PUBLIC |
- |
Reserved |
Reserved |
QUERY |
Non-reserved |
- |
- |
QUOTE |
Non-reserved |
- |
- |
RANGE |
Non-reserved |
- |
- |
RAW |
Non-reserved |
- |
- |
READ |
Non-reserved |
Reserved |
Reserved |
READS |
- |
Reserved |
- |
REAL |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
REASSIGN |
Non-reserved |
- |
- |
REBUILD |
Non-reserved |
- |
- |
RECHECK |
Non-reserved |
- |
- |
RECURSIVE |
Non-reserved |
Reserved |
- |
REF |
Non-reserved |
Reserved |
- |
REFRESH |
Non-reserved |
- |
- |
REFERENCES |
Reserved |
Reserved |
Reserved |
REFERENCING |
- |
Reserved |
- |
REINDEX |
Non-reserved |
- |
- |
REJECT |
Reserved |
- |
- |
RELATIVE |
Non-reserved |
Reserved |
Reserved |
RELEASE |
Non-reserved |
- |
- |
RELOPTIONS |
Non-reserved |
- |
- |
REMOTE |
Non-reserved |
- |
- |
RENAME |
Non-reserved |
- |
- |
REPEATABLE |
Non-reserved |
Non-reserved |
Non-reserved |
REPLACE |
Non-reserved |
- |
- |
REPLICA |
Non-reserved |
- |
- |
RESET |
Non-reserved |
- |
- |
RESIZE |
Non-reserved |
- |
- |
RESOURCE |
Non-reserved |
- |
- |
RESTART |
Non-reserved |
- |
- |
RESTRICT |
Non-reserved |
Reserved |
Reserved |
RESULT |
- |
Reserved |
- |
RETURN |
Non-reserved |
Reserved |
- |
RETURNED_LENGTH |
- |
Non-reserved |
Non-reserved |
RETURNED_OCTET_LENGTH |
- |
Non-reserved |
Non-reserved |
RETURNED_SQLSTATE |
- |
Non-reserved |
Non-reserved |
RETURNING |
Reserved |
- |
- |
RETURNS |
Non-reserved |
Reserved |
- |
REUSE |
Non-reserved |
- |
- |
REVOKE |
Non-reserved |
Reserved |
Reserved |
RIGHT |
Reserved (functions and types allowed) |
Reserved |
Reserved |
ROLE |
Non-reserved |
Reserved |
- |
ROLLBACK |
Non-reserved |
Reserved |
Reserved |
ROLLUP |
- |
Reserved |
- |
ROUTINE |
- |
Reserved |
- |
ROUTINE_CATALOG |
- |
Non-reserved |
- |
ROUTINE_NAME |
- |
Non-reserved |
- |
ROUTINE_SCHEMA |
- |
Non-reserved |
- |
ROW |
Non-reserved (excluding functions and types) |
Reserved |
- |
ROWS |
Non-reserved |
Reserved |
Reserved |
ROW_COUNT |
- |
Non-reserved |
Non-reserved |
RULE |
Non-reserved |
- |
- |
SAVEPOINT |
Non-reserved |
Reserved |
- |
SCALE |
- |
Non-reserved |
Non-reserved |
SCHEMA |
Non-reserved |
Reserved |
Reserved |
SCHEMA_NAME |
- |
Non-reserved |
Non-reserved |
SCOPE |
- |
Reserved |
- |
SCROLL |
Non-reserved |
Reserved |
Reserved |
SEARCH |
Non-reserved |
Reserved |
- |
SECOND |
Non-reserved |
Reserved |
Reserved |
SECTION |
- |
Reserved |
Reserved |
SECURITY |
Non-reserved |
Non-reserved |
- |
SELECT |
Reserved |
Reserved |
Reserved |
SELF |
- |
Non-reserved |
- |
SENSITIVE |
- |
Non-reserved |
- |
SEPARATOR |
Non-reserved |
- |
- |
SEQUENCE |
Non-reserved |
Reserved |
- |
SEQUENCES |
Non-reserved |
- |
- |
SERIALIZABLE |
Non-reserved |
Non-reserved |
Non-reserved |
SERVER |
Non-reserved |
- |
- |
SERVER_NAME |
- |
Non-reserved |
Non-reserved |
SESSION |
Non-reserved |
Reserved |
Reserved |
SESSION_USER |
Reserved |
Reserved |
Reserved |
SET |
Non-reserved |
Reserved |
Reserved |
SETOF |
Non-reserved (excluding functions and types) |
- |
- |
SETS |
- |
Reserved |
- |
SHARE |
Non-reserved |
- |
- |
SHIPPABLE |
Non-reserved |
- |
- |
SHOW |
Non-reserved |
- |
- |
SIMILAR |
Reserved (functions and types allowed) |
Non-reserved |
- |
SIMPLE |
Non-reserved |
Non-reserved |
- |
SIZE |
Non-reserved |
Reserved |
Reserved |
SMALLDATETIME |
Non-reserved (excluding functions and types) |
- |
- |
SMALLDATETIME_FORMAT |
Non-reserved |
- |
- |
SMALLINT |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
SNAPSHOT |
Non-reserved |
- |
- |
SOME |
Reserved |
Reserved |
Reserved |
SOURCE |
Non-reserved |
Non-reserved |
- |
SPACE |
- |
Reserved |
Reserved |
SPECIFIC |
- |
Reserved |
- |
SPECIFICTYPE |
- |
Reserved |
- |
SPECIFIC_NAME |
- |
Non-reserved |
- |
SPILL |
Non-reserved |
- |
- |
SPLIT |
Non-reserved |
- |
- |
SQL |
- |
Reserved |
Reserved |
SQLCODE |
- |
- |
Reserved |
SQLERROR |
- |
- |
Reserved |
SQLEXCEPTION |
- |
Reserved |
- |
SQLSTATE |
- |
Reserved |
Reserved |
SQLWARNING |
- |
Reserved |
- |
STABLE |
Non-reserved |
- |
- |
STANDALONE |
Non-reserved |
- |
- |
START |
Non-reserved |
Reserved |
- |
STATE |
- |
Reserved |
- |
STATEMENT |
Non-reserved |
Reserved |
- |
STATEMENT_ID |
Non-reserved |
- |
- |
STATIC |
- |
Reserved |
- |
STATISTICS |
Non-reserved |
- |
- |
STDIN |
Non-reserved |
- |
- |
STDOUT |
Non-reserved |
- |
- |
STORAGE |
Non-reserved |
- |
- |
STORE |
Non-reserved |
- |
- |
STRICT |
Non-reserved |
- |
- |
STRIP |
Non-reserved |
- |
- |
STRUCTURE |
- |
Reserved |
- |
STYLE |
- |
Non-reserved |
- |
SUBCLASS_ORIGIN |
- |
Non-reserved |
Non-reserved |
SUBLIST |
- |
Non-reserved |
- |
SUBSTRING |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
SUM |
- |
Non-reserved |
Reserved |
SUPERUSER |
Non-reserved |
- |
- |
SYMMETRIC |
Reserved |
Non-reserved |
- |
SYNONYM |
Non-reserved |
- |
- |
SYS_REFCURSOR |
Non-reserved |
- |
- |
SYSDATE |
Reserved |
- |
- |
SYSID |
Non-reserved |
- |
- |
SYSTEM |
Non-reserved |
Non-reserved |
- |
SYSTEM_USER |
- |
Reserved |
Reserved |
TABLE |
Reserved |
Reserved |
Reserved |
TABLES |
Non-reserved |
- |
- |
TABLE_NAME |
- |
Non-reserved |
Non-reserved |
TEMP |
Non-reserved |
- |
- |
TEMPLATE |
Non-reserved |
- |
- |
TEMPORARY |
Non-reserved |
Reserved |
Reserved |
TERMINATE |
- |
Reserved |
- |
TEXT |
Non-reserved |
- |
- |
THAN |
Non-reserved |
Reserved |
- |
THEN |
Reserved |
Reserved |
Reserved |
TIME |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
TIME_FORMAT |
Non-reserved |
- |
- |
TIMESTAMP |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
TIMESTAMPADD |
Non-reserved (excluding functions and types) |
- |
- |
TIMESTAMPDIFF |
Non-reserved (excluding functions and types) |
- |
- |
TIMESTAMP_FORMAT |
Non-reserved |
- |
- |
TIMEZONE_HOUR |
- |
Reserved |
Reserved |
TIMEZONE_MINUTE |
- |
Reserved |
Reserved |
TINYINT |
Non-reserved (excluding functions and types) |
- |
- |
TO |
Reserved |
Reserved |
Reserved |
TRAILING |
Reserved |
Reserved |
Reserved |
TRANSACTION |
Non-reserved |
Reserved |
Reserved |
TRANSACTIONS_COMMITTED |
- |
Non-reserved |
- |
TRANSACTIONS_ROLLED_BACK |
- |
Non-reserved |
- |
TRANSACTION_ACTIVE |
- |
Non-reserved |
- |
TRANSFORM |
- |
Non-reserved |
- |
TRANSFORMS |
- |
Non-reserved |
- |
TRANSLATE |
- |
Non-reserved |
Reserved |
TRANSLATION |
- |
Reserved |
Reserved |
TREAT |
Non-reserved (excluding functions and types) |
Reserved |
- |
TRIGGER |
Non-reserved |
Reserved |
- |
TRIGGER_CATALOG |
- |
Non-reserved |
- |
TRIGGER_NAME |
- |
Non-reserved |
- |
TRIGGER_SCHEMA |
- |
Non-reserved |
- |
TRIM |
Non-reserved (excluding functions and types) |
Non-reserved |
Reserved |
TRUE |
Reserved |
Reserved |
Reserved |
TRUNCATE |
Non-reserved |
- |
- |
TRUSTED |
Non-reserved |
- |
- |
TSTAG |
Reserved. This field is used only in the hybrid data warehouse. |
- |
- |
TSTIME |
Reserved. This field is used only in the hybrid data warehouse. |
- |
- |
TSFIELD |
Reserved. This field is used only in the hybrid data warehouse. |
- |
- |
TYPE |
Non-reserved |
Non-reserved |
Non-reserved |
TYPES |
Non-reserved |
- |
- |
UESCAPE |
- |
- |
- |
UNBOUNDED |
Non-reserved |
- |
- |
UNCOMMITTED |
Non-reserved |
Non-reserved |
Non-reserved |
UNDER |
- |
Reserved |
- |
UNENCRYPTED |
Non-reserved |
- |
- |
UNION |
Reserved |
Reserved |
Reserved |
UNIQUE |
Reserved |
Reserved |
Reserved |
UNKNOWN |
Non-reserved |
Reserved |
Reserved |
UNLIMITED |
Non-reserved |
- |
- |
UNLISTEN |
Non-reserved |
- |
- |
UNLOCK |
Non-reserved |
- |
- |
UNLOGGED |
Non-reserved |
- |
- |
UNNAMED |
- |
Non-reserved |
Non-reserved |
UNNEST |
- |
Reserved |
- |
UNTIL |
Non-reserved |
- |
- |
UNUSABLE |
Non-reserved |
- |
- |
UPDATE |
Non-reserved |
Reserved |
Reserved |
UPPER |
- |
Non-reserved |
Reserved |
USAGE |
- |
Reserved |
Reserved |
USER |
Reserved |
Reserved |
Reserved |
USER_DEFINED_TYPE_CATALOG |
- |
Non-reserved |
- |
USER_DEFINED_TYPE_NAME |
- |
Non-reserved |
- |
USER_DEFINED_TYPE_SCHEMA |
- |
Non-reserved |
- |
USING |
Reserved |
Reserved |
Reserved |
VACUUM |
Non-reserved |
- |
- |
VALID |
Non-reserved |
- |
- |
VALIDATE |
Non-reserved |
- |
- |
VALIDATION |
Non-reserved |
- |
- |
VALIDATOR |
Non-reserved |
- |
- |
VALUE |
Non-reserved |
Reserved |
Reserved |
VALUES |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
VARCHAR |
Non-reserved (excluding functions and types) |
Reserved |
Reserved |
VARCHAR2 |
Non-reserved (excluding functions and types) |
- |
- |
VARIABLE |
- |
Reserved |
- |
VARIADIC |
Reserved |
- |
- |
VARYING |
Non-reserved |
Reserved |
Reserved |
VCGROUP |
Non-reserved |
- |
- |
VERBOSE |
Reserved (functions and types allowed) |
- |
- |
VERIFY |
Non-reserved |
- |
- |
VERSION |
Non-reserved |
- |
- |
VIEW |
Non-reserved |
Reserved |
Reserved |
VOLATILE |
Non-reserved |
- |
- |
WHEN |
Reserved |
Reserved |
Reserved |
WHENEVER |
- |
Reserved |
Reserved |
WHERE |
Reserved |
Reserved |
Reserved |
WHITESPACE |
Non-reserved |
- |
- |
WINDOW |
Reserved |
- |
- |
WITH |
Reserved |
Reserved |
Reserved |
WITHIN |
Non-reserved |
- |
- |
WITHOUT |
Non-reserved |
Reserved |
- |
WORK |
Non-reserved |
Reserved |
Reserved |
WORKLOAD |
Non-reserved |
- |
- |
WRAPPER |
Non-reserved |
- |
- |
WRITE |
Non-reserved |
Reserved |
Reserved |
XML |
Non-reserved |
- |
- |
XMLATTRIBUTES |
Non-reserved (excluding functions and types) |
- |
- |
XMLCONCAT |
Non-reserved (excluding functions and types) |
- |
- |
XMLELEMENT |
Non-reserved (excluding functions and types) |
- |
- |
XMLEXISTS |
Non-reserved (excluding functions and types) |
- |
- |
XMLFOREST |
Non-reserved (excluding functions and types) |
- |
- |
XMLNAMESPACES |
Non-reserved (excluding functions and types) |
- |
- |
XMLPARSE |
Non-reserved (excluding functions and types) |
- |
- |
XMLPI |
Non-reserved (excluding functions and types) |
- |
- |
XMLROOT |
Non-reserved (excluding functions and types) |
- |
- |
XMLSERIALIZE |
Non-reserved (excluding functions and types) |
- |
- |
XMLTABLE |
Non-reserved (excluding functions and types) |
- |
- |
YEAR |
Non-reserved |
Reserved |
Reserved |
YES |
Non-reserved |
- |
- |
ZONE |
Non-reserved |
Reserved |
Reserved |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot