Keywords
SQL contains both reserved and non-reserved words. According to the standard, reserved words must not be used as other identifiers. Non-reserved words have special meanings only in specific contexts and can be used as identifiers in other contexts.
|
Keyword |
DataArts Fabric SQL |
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 (can be a function or type) |
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 (cannot be a function or type) |
Non-reserved |
Reserved |
|
BIGINT |
Non-reserved (cannot be a function or type) |
- |
- |
|
BINARY |
Reserved (can be a function or type) |
Reserved |
- |
|
BINARY_DOUBLE |
Non-reserved (cannot be a function or type) |
- |
- |
|
BINARY_INTEGER |
Non-reserved (cannot be a function or type) |
- |
- |
|
BIT |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
BITVAR |
- |
Non-reserved |
- |
|
BIT_LENGTH |
- |
Non-reserved |
Reserved |
|
BLOB |
Non-reserved |
Reserved |
- |
|
BOOLEAN |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
Reserved |
Reserved |
|
CHARACTER |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
Non-reserved |
Reserved |
|
COBOL |
- |
Non-reserved |
Non-reserved |
|
COLLATE |
Reserved |
Reserved |
Reserved |
|
COLLATION |
Reserved (can be a function or type) |
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 (can be a function or type) |
- |
- |
|
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 (can be a function or type) |
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 (can be a function or type) |
- |
- |
|
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 (cannot be a function or type) |
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 (cannot be a function or type) |
Reserved |
Reserved |
|
DECIMAL |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
DECLARE |
Non-reserved |
Reserved |
Reserved |
|
DECODE |
Non-reserved (cannot be a function or type) |
- |
- |
|
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 (cannot be a function or type) |
Non-reserved |
Reserved |
|
EXPIRATION |
Non-reserved |
- |
- |
|
EXPLAIN |
Non-reserved |
- |
- |
|
EXTENSION |
Non-reserved |
- |
- |
|
EXTERNAL |
Non-reserved |
Reserved |
Reserved |
|
EXTRACT |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
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 (can be a function or type) |
- |
- |
|
FROM |
Reserved |
Reserved |
Reserved |
|
FULL |
Reserved (can be a function or type) |
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 (cannot be a function or type) |
- |
- |
|
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 (cannot be a function or type) |
- |
- |
|
IFNULL |
Non-reserved (cannot be a function or type) |
- |
- |
|
IGNORE |
- |
Reserved |
- |
|
IGNORE_EXTRA_DATA |
Non-reserved |
- |
- |
|
ILIKE |
Reserved (can be a function or type) |
- |
- |
|
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 (can be a function or type) |
Reserved |
Reserved |
|
INOUT |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
Reserved |
Reserved |
|
INTEGER |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
INTERNAL |
Reserved |
- |
- |
|
INTERSECT |
Reserved |
Reserved |
Reserved |
|
INTERVAL |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
INTO |
Reserved |
Reserved |
Reserved |
|
INVOKER |
Non-reserved |
Non-reserved |
- |
|
IS |
Reserved |
Reserved |
Reserved |
|
ISNULL |
Non-reserved (cannot be a function or type) |
- |
- |
|
ISOLATION |
Non-reserved |
Reserved |
Reserved |
|
ITERATE |
- |
Reserved |
- |
|
JOIN |
Reserved (can be a function or type) |
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 (cannot be a function or type) |
- |
- |
|
LEFT |
Reserved (can be a function or type) |
Reserved |
Reserved |
|
LENGTH |
- |
Non-reserved |
Non-reserved |
|
LESS |
Reserved |
Reserved |
- |
|
LEVEL |
Non-reserved |
Reserved |
Reserved |
|
LIKE |
Reserved (can be a function or type) |
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 (cannot be a function or type) |
Reserved |
Reserved |
|
NATURAL |
Reserved (can be a function or type) |
Reserved |
Reserved |
|
NCHAR |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
Reserved |
- |
|
NOT |
Reserved |
Reserved |
Reserved |
|
NOTHING |
Non-reserved |
- |
- |
|
NOTIFY |
Non-reserved |
- |
- |
|
NOTNULL |
Reserved (can be a function or type) |
- |
- |
|
NOWAIT |
Non-reserved |
- |
- |
|
NULL |
Reserved |
Reserved |
Reserved |
|
NULLABLE |
- |
Non-reserved |
Non-reserved |
|
NULLIF |
Non-reserved (cannot be a function or type) |
Non-reserved |
Reserved |
|
NULLS |
Non-reserved |
- |
- |
|
NUMBER |
Non-reserved (cannot be a function or type) |
Non-reserved |
Non-reserved |
|
NUMERIC |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
NUMSTR |
Non-reserved |
- |
- |
|
NVARCHAR2 |
Non-reserved (cannot be a function or type) |
- |
- |
|
NVL |
Non-reserved (cannot be a function or type) |
- |
- |
|
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 (cannot be a function or type) |
Reserved |
- |
|
OUTER |
Reserved (can be a function or type) |
Reserved |
Reserved |
|
OUTPUT |
- |
Reserved |
Reserved |
|
OVER |
Non-reserved |
- |
- |
|
OVERLAPS |
Reserved (can be a function or type) |
Non-reserved |
Reserved |
|
OVERLAY |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
Non-reserved |
Reserved |
|
POSTFIX |
- |
Reserved |
- |
|
PRECEDING |
Non-reserved |
- |
- |
|
PRECISION |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
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 (can be a function or type) |
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 (cannot be a function or type) |
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 (cannot be a function or type) |
- |
- |
|
SETS |
- |
Reserved |
- |
|
SHARE |
Non-reserved |
- |
- |
|
SHIPPABLE |
Non-reserved |
- |
- |
|
SHOW |
Non-reserved |
- |
- |
|
SIMILAR |
Reserved (can be a function or type) |
Non-reserved |
- |
|
SIMPLE |
Non-reserved |
Non-reserved |
- |
|
SIZE |
Non-reserved |
Reserved |
Reserved |
|
SMALLDATETIME |
Non-reserved (cannot be a function or type) |
- |
- |
|
SMALLDATETIME_FORMAT |
Non-reserved |
- |
- |
|
SMALLINT |
Non-reserved (cannot be a function or type) |
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 (cannot be a function or type) |
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 (cannot be a function or type) |
Reserved |
Reserved |
|
TIME_FORMAT |
Non-reserved |
- |
- |
|
TIMESTAMP |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
TIMESTAMPADD |
Non-reserved (cannot be a function or type) |
- |
- |
|
TIMESTAMPDIFF |
Non-reserved (cannot be a function or type) |
- |
- |
|
TIMESTAMP_FORMAT |
Non-reserved |
- |
- |
|
TIMEZONE_HOUR |
- |
Reserved |
Reserved |
|
TIMEZONE_MINUTE |
- |
Reserved |
Reserved |
|
TINYINT |
Non-reserved (cannot be a function or type) |
- |
- |
|
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 (cannot be a function or type) |
Reserved |
- |
|
TRIGGER |
Non-reserved |
Reserved |
- |
|
TRIGGER_CATALOG |
- |
Non-reserved |
- |
|
TRIGGER_NAME |
- |
Non-reserved |
- |
|
TRIGGER_SCHEMA |
- |
Non-reserved |
- |
|
TRIM |
Non-reserved (cannot be a function or type) |
Non-reserved |
Reserved |
|
TRUE |
Reserved |
Reserved |
Reserved |
|
TRUNCATE |
Non-reserved |
- |
- |
|
TRUSTED |
Non-reserved |
- |
- |
|
TRY_CAST |
Non-reserved |
- |
- |
|
TSTAG |
Reserved. This field is only used in the stream data warehouse. |
- |
- |
|
TSTIME |
Reserved. This field is only used in the stream data warehouse. |
- |
- |
|
TSFIELD |
Reserved. This field is only used in the stream 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 (cannot be a function or type) |
Reserved |
Reserved |
|
VARCHAR |
Non-reserved (cannot be a function or type) |
Reserved |
Reserved |
|
VARCHAR2 |
Non-reserved (cannot be a function or type) |
- |
- |
|
VARIABLE |
- |
Reserved |
- |
|
VARIADIC |
Reserved |
- |
- |
|
VARYING |
Non-reserved |
Reserved |
Reserved |
|
VCGROUP |
Non-reserved |
- |
- |
|
VERBOSE |
Reserved (can be a function or type) |
- |
- |
|
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 (cannot be a function or type) |
- |
- |
|
XMLCONCAT |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLELEMENT |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLEXISTS |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLFOREST |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLNAMESPACES |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLPARSE |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLPI |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLROOT |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLSERIALIZE |
Non-reserved (cannot be a function or type) |
- |
- |
|
XMLTABLE |
Non-reserved (cannot be a function or type) |
- |
- |
|
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