This system table contains all SQL keywords in Exasol. All users have access to this table.
| Column | Description |
|---|---|
KEYWORD
|
Keyword |
RESERVED
|
Defines whether the keyword is a reserved word. Reserved words cannot be used as a SQL identifier. |
To learn more about SQL identifiers, see SQL identifier.
Reserved keywords
The following keywords are reserved words that cannot be used as a SQL identifier.
The following list is valid for Exasol 2025.2.0. If you have a different version of Exasol, check the system table for a complete list of the reserved keywords in that version.
A
ABSOLUTE
ACTION
ADD
AFTER
ALL
ALLOCATE
ALTER
AND
ANY
APPEND
ARE
ARRAY
AS
ASC
ASENSITIVE
ASSERTION
AT
ATTRIBUTE
AUTHID
AUTHORIZATION
B
BEFORE
BEGIN
BETWEEN
BIGINT
BINARY
BIT
BLOB
BLOCKED
BOOL
BOOLEAN
BOTH
BY
BYTE
C
CALL
CALLED
CARDINALITY
CASCADE
CASCADED
CASE
CASESPECIFIC
CAST
CATALOG
CHAIN
CHAR
CHARACTER
CHARACTERISTICS
CHARACTER_SET_CATALOG
CHARACTER_SET_NAME
CHARACTER_SET_SCHEMA
CHECK
CHECKED
CLOB
CLOSE
COALESCE
COLLATE
COLLATION
COLLATION_CATALOG
COLLATION_NAME
COLLATION_SCHEMA
COLUMN
COMMIT
CONDITION
CONNECTION
CONNECT_BY_ISCYCLE
CONNECT_BY_ISLEAF
CONNECT_BY_ROOT
CONSTANT
CONSTRAINT
CONSTRAINTS
CONSTRAINT_STATE_DEFAULT
CONSTRUCTOR
CONTAINS
CONTINUE
CONTROL
CONVERT
CORRESPONDING
CREATE
CS
CSV
CUBE
CURRENT
CURRENT_CLUSTER
CURRENT_CLUSTER_UID
CURRENT_DATE
CURRENT_PATH
CURRENT_ROLE
CURRENT_SCHEMA
CURRENT_SESSION
CURRENT_STATEMENT
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CYCLE
D
DATA
DATALINK
DATE
DATETIME_INTERVAL_CODE
DATETIME_INTERVAL_PRECISION
DAY
DBTIMEZONE
DEALLOCATE
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULT_LIKE_ESCAPE_CHARACTER
DEFERRABLE
DEFERRED
DEFINED
DEFINER
DELETE
DEREF
DERIVED
DESC
DESCRIBE
DESCRIPTOR
DETERMINISTIC
DISABLE
DISABLED
DISCONNECT
DISPATCH
DISTINCT
DLURLCOMPLETE
DLURLPATH
DLURLPATHONLY
DLURLSCHEME
DLURLSERVER
DLVALUE
DO
DOMAIN
DOUBLE
DROP
DYNAMIC
DYNAMIC_FUNCTION
DYNAMIC_FUNCTION_CODE
E
EACH
ELSE
ELSEIF
ELSIF
EMITS
ENABLE
ENABLED
END
END-EXEC
ENDIF
ENFORCE
EQUALS
ERRORS
ESCAPE
EXCEPT
EXCEPTION
EXEC
EXECUTE
EXISTS
EXIT
EXPORT
EXTERNAL
EXTRACT
F
FALSE
FBV
FETCH
FILE
FINAL
FIRST
FLOAT
FOLLOWING
FOR
FORALL
FORCE
FORMAT
FOUND
FREE
FROM
FS
FULL
FUNCTION
G
GENERAL
GENERATED
GEOMETRY
GET
GLOBAL
GO
GOTO
GRANT
GRANTED
GROUP
GROUPING
GROUPS
GROUP_CONCAT
H
HASHTYPE
HASHTYPE_FORMAT
HAVING
HIGH
HOLD
HOUR
I
IDENTITY
IF
IFNULL
IMMEDIATE
IMPERSONATE
IMPLEMENTATION
IMPORT
IN
INDEX
INDICATOR
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSTANCE
INSTANTIABLE
INT
INTEGER
INTEGRITY
INTERSECT
INTERVAL
INTO
INVERSE
INVOKER
IS
ITERATE
J
JOIN
K
KEY_MEMBER
KEY_TYPE
L
LARGE
LAST
LATERAL
LDAP
LEADING
LEAVE
LEFT
LEVEL
LIKE
LIMIT
LISTAGG
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATOR
LOG
LONGVARCHAR
LOOP
LOW
M
MAP
MATCH
MATCHED
MERGE
METHOD
MINUS
MINUTE
MOD
MODIFIES
MODIFY
MODULE
MONTH
N
NAMES
NATIONAL
NATURAL
NCHAR
NCLOB
NEW
NEXT
NLS_DATE_FORMAT
NLS_DATE_LANGUAGE
NLS_FIRST_DAY_OF_WEEK
NLS_NUMERIC_CHARACTERS
NLS_TIMESTAMP_FORMAT
NO
NOCYCLE
NOLOGGING
NONE
NOT
NULL
NULLIF
NUMBER
NUMERIC
NVARCHAR
NVARCHAR2
O
OBJECT
OF
OFF
OLD
ON
ONLY
OPEN
OPTION
OPTIONS
OR
ORDER
ORDERING
ORDINALITY
OTHERS
OUT
OUTER
OUTPUT
OVER
OVERLAPS
OVERLAY
OVERRIDING
P
PAD
PARALLEL_ENABLE
PARAMETER
PARAMETER_SPECIFIC_CATALOG
PARAMETER_SPECIFIC_NAME
PARAMETER_SPECIFIC_SCHEMA
PARQUET
PARTIAL
PATH
PERMISSION
PLACING
PLUS
POSITION
PRECEDING
PREFERRING
PREPARE
PRESERVE
PRIOR
PRIVILEGES
PROCEDURE
PROFILE
Q
QUALIFY
R
RANDOM
RANGE
READ
READS
REAL
RECOVERY
RECURSIVE
REF
REFERENCES
REFERENCING
REFRESH
REGEXP_LIKE
RELATIVE
RELEASE
RENAME
REPEAT
REPLACE
RESTORE
RESTRICT
RESULT
RETURN
RETURNED_LENGTH
RETURNED_OCTET_LENGTH
RETURNS
REVOKE
RIGHT
ROLLBACK
ROLLUP
ROUTINE
ROW
ROWS
ROWTYPE
S
SAVEPOINT
SCHEMA
SCOPE
SCOPE_USER
SCRIPT
SCROLL
SEARCH
SECOND
SECTION
SECURITY
SELECT
SELECTIVE
SELF
SENSITIVE
SEPARATOR
SEQUENCE
SESSION
SESSIONTIMEZONE
SESSION_USER
SET
SETS
SHORTINT
SIMILAR
SMALLINT
SOME
SOURCE
SPACE
SPECIFIC
SPECIFICTYPE
SQL
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQL_BIGINT
SQL_BIT
SQL_CHAR
SQL_DATE
SQL_DECIMAL
SQL_DOUBLE
SQL_FLOAT
SQL_INTEGER
SQL_LONGVARCHAR
SQL_NUMERIC
SQL_PREPROCESSOR_SCRIPT
SQL_REAL
SQL_SMALLINT
SQL_TIMESTAMP
SQL_TINYINT
SQL_TYPE_DATE
SQL_TYPE_TIMESTAMP
SQL_VARCHAR
START
STATE
STATEMENT
STATIC
STRUCTURE
STYLE
SUBSTRING
SUBTYPE
SYSDATE
SYSTEM
SYSTEM_USER
SYSTIMESTAMP
T
TABLE
TEMPORARY
TEXT
THEN
TIME
TIMESTAMP
TIMEZONE_HOUR
TIMEZONE_MINUTE
TINYINT
TO
TRAILING
TRANSACTION
TRANSFORM
TRANSFORMS
TRANSLATION
TREAT
TRIGGER
TRIM
TRUE
TRUNCATE
U
UNDER
UNION
UNIQUE
UNKNOWN
UNLINK
UNNEST
UNTIL
UPDATE
USAGE
USER
USING
V
VALUE
VALUES
VARCHAR
VARCHAR2
VARRAY
VERIFY
VIEW
W
WHEN
WHENEVER
WHERE
WHILE
WINDOW
WITH
WITHIN
WITHOUT
WORK
XYZ
YEAR
YES
ZONE
