Keyword
The SQL contains reserved and non-reserved words. Reserved keywords must not be used as other identifiers in accordance with standards. 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:1992 |
---|---|---|---|
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 |
- |
- |
TRY_CAST |
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.