List of Restricted Keywords
On this page
A
ABORT
ABS
ABSOLUTE
ACCESS
ACCOUNT
ACOS
ACTION
ADD
ADDDATE
ADDTIME
ADMIN
AES_
AES_
AFTER
AGAINST
AGGREGATE
AGGREGATES
AGGREGATOR
AGGREGATOR_
AGGREGATOR_
AGGREGATORS
ALGORITHM
ALL
ALSO
ALTER
ALWAYS
ANALYSE
ANALYZE
AND
ANTI_
ANY
ANY_
APPROX_
APPROX_
APPROX_
APPROX_
APPROX_
APPROX_
ARGHISTORY
ARRANGE
ARRANGEMENT
ARRAY
AS
ASC
ASCII
ASENSITIVE
ASIN
ASM
ASSERTION
ASSIGNMENT
AST
ASYMMETRIC
ASYNC
AT
ATAN
ATAN2
ATTACH
ATTRIBUTE
AUTHORIZATION
AUTO
AUTO_
AUTO_
AUTOSTATS
AUTOSTATS_
AUTOSTATS_
AUTOSTATS_
AUTOSTATS_
AVAILABILITY
AVG
AVG_
AVRO
AZURE
B
BACKGROUND
_
BACKUP
BACKUP_
BACKUP_
BACKWARD
BATCH
BATCHES
BATCH_
_
BEFORE
BEGIN
BETWEEN
BIGINT
BIN
BINARY
_
BIT
BIT_
BIT_
BIT_
BIT_
BLOB
BOOL
BOOLEAN
BOOTSTRAP
BOTH
_
BTREE
BUCKET_
BY
BYTE
BYTE_
C
CACHE
CALL
CALL_
CALLED
CAPTURE
CASCADE
CASCADED
CASE
CAST
CATALOG
CEIL
CEILING
CHAIN
CHANGE
CHAR
CHARACTER
CHARACTERISTICS
CHARACTER_
CHAR_
CHARSET
CHECK
CHECKPOINT
_
_
CHECKSUM
_
CLASS
CLEAR
CLIENT
CLIENT_
CLOSE
CLUSTER
CLUSTERED
CNF
COALESCE
COERCIBILITY
COLLATE
COLLATION
COLLECT
COLUMN
COLUMNAR
COLUMNS
COLUMNSTORE
COLUMNSTORE_
COMMENT
COMMENTS
COMMIT
COMMITTED
_
COMMITTED
COMPACT
COMPILE
COMPRESSED
COMPRESSION
CONCAT
CONCAT_
CONCURRENT
CONCURRENTLY
CONDITION
CONFIGURATION
CONNECTION
CONNECTION_
CONNECTIONS
CONFIG
CONSTRAINT
CONSTRAINTS
CONTENT
CONTINUE
_
CONV
CONVERSION
CONVERT
CONVERT_
COPY
_
COS
COST
COT
COUNT
CREATE
CREDENTIALS
CROSS
CUBE
CSV
CUME_
CURDATE
CURRENT
CURRENT_
CURRENT_
CURRENT_
CURRENT_
CURRENT_
CURRENT_
CURRENT_
CURRENT_
CURRENT_
CURSOR
CURTIME
CYCLE
D
DATA
DATABASE
DATABASES
DATE
DATE_
DATEDIFF
DATE_
DATE_
DATE_
DATETIME
DAY
DAY_
DAY_
DAY_
DAYNAME
DAYOFMONTH
DAYOFWEEK
DAYOFYEAR
DAY_
DEALLOCATE
DEC
DECIMAL
DECLARE
DECODE
DEFAULT
DEFAULTS
DEFERRABLE
DEFERRED
DEFINED
DEFINER
DEGREES
DELAYED
DELAY_
DELETE
DELIMITER
DELIMITERS
DENSE_
DESC
DESCRIBE
DETACH
DETERMINISTIC
DICTIONARY
DIFFERENTIAL
DIRECTORY
DISABLE
DISCARD
_
DISK
DISTINCT
DISTINCTROW
DISTRIBUTED_
DIV
DO
DOCUMENT
DOMAIN
DOT_
DOUBLE
DROP
_
DUAL
DUMP
DUPLICATE
DYNAMIC
E
EARLIEST
EACH
ECHO
ELECTION
ELSE
ELSEIF
ELT
ENABLE
ENCLOSED
ENCODING
ENCRYPTED
END
ENGINE
ENGINES
ENUM
ERRORS
ESCAPE
ESCAPED
ESTIMATE
EUCLIDEAN_
EVENT
EVENTS
EXCEPT
EXCLUDE
EXCLUDING
EXCLUSIVE
EXECUTE
EXISTS
EXIT
EXP
EXPLAIN
EXTENDED
EXTENSION
EXTERNAL
EXTERNAL_
EXTERNAL_
EXTRACT
EXTRACTOR
EXTRACTORS
EXTRA_
F
_
FAILED_
FAILURE
FALSE
FAMILY
FAULT
FETCH
FIELD
FIELDS
FILE
FILES
FILL
FIRST
FIRST_
FIX_
FIXED
FLOAT
FLOAT4
FLOAT8
FLOOR
FLUSH
FOLLOWING
FOR
FORCE
FORCE_
FORCE_
FOREGROUND
FOREIGN
FORMAT
FORWARD
FOUND_
FREEZE
FROM
FROM_
FROM_
FROM_
FS
_
FULL
FULLTEXT
FUNCTION
FUNCTIONS
G
GC
GCS
GET_
_
_
GENERATE
GEOGRAPHY
GEOGRAPHY_
GEOGRAPHY_
GEOGRAPHY_
GEOGRAPHY_
GEOGRAPHY_
GEOGRAPHY_
GEOGRAPHY_
GEOGRAPHYPOINT
GEOGRAPHY_
GEOGRAPHY_
GEOMETRY
GEOMETRY_
GEOMETRY_
GEOMETRY_
GEOMETRY_
GEOMETRY_
GEOMETRY_
GEOMETRYPOINT
GEOMETRY_
GEOMETRY_
GEOMETRY_
GEOMETRY_
GLOBAL
_
GRANT
GRANTED
GRANTS
GREATEST
GROUP
GROUPING
GROUPS
GROUP_
GZIP
H
HANDLE
HANDLER
HARD_
HASH
HAS_
HAVING
HDFS
HEADER
HEARTBEAT_
HEX
HIGHLIGHT
HIGH_
HOLD
HOLDING
HOST
HOSTS
HOUR
HOUR_
HOUR_
HOUR_
I
IDENTIFIED
IDENTITY
IF
IFNULL
IGNORE
ILIKE
IMMEDIATE
IMMUTABLE
IMPLICIT
IMPORT
IN
INCLUDING
INCREMENT
INCREMENTAL
INDEX
INDEXES
INET_
INET_
INET6_
INET6_
INFILE
INHERIT
INHERITS
_
INIT
INITCAP
INITIALIZE
INITIALLY
INJECT
INLINE
INNER
INOUT
INPUT
INSENSITIVE
INSERT
INSERT_
INSTANCE
INSTEAD
INSTR
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
_
INTERPRETER_
INTERSECT
INTERVAL
INTO
INVOKER
IS
ISNULL
ISOLATION
ITERATE
J
JOIN
JSON
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
JSON_
K
KAFKA
KEY
KEY_
KEYS
KILL
KILLALL
L
LABEL
LAG
LANGUAGE
LARGE
LAST
LAST_
LAST_
LAST_
LATERAL
LATEST
LC_
LC_
LCASE
LEAD
LEADING
LEAF
LEAKPROOF
LEAST
LEAVE
LEAVES
LEFT
LENGTH
LEVEL
LICENSE
LIKE
LIMIT
LINES
LISTEN
LLVM
LN
LOAD
LOADDATA_
_
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCATE
LOCATION
LOCK
LOG
LOG10
LOG2
LONG
LONGBLOB
LONGTEXT
LOOP
LOWER
LOW_
LPAD
_
LTRIM
LZ4
M
MANAGEMENT
_
MAPPING
MASTER
MATCH
MATERIALIZED
MAX
MAXVALUE
MAX_
MAX_
MAX_
MAX_
MAX_
MAX_
MBC
MD5
MPL
MEDIAN
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MEMBER
MEMORY
MEMORY_
_
MEMSQL
MEMSQL_
MEMSQL_
MEMSQL_
MERGE
METADATA
MICROSECOND
MIDDLEINT
MIN
MIN_
MINUS
MINUTE
MINUTE_
MINUTE_
MINVALUE
MOD
MODE
MODEL
MODIFIES
MODIFY
MONTH
MONTHNAME
MONTHS_
MOVE
MPL
N
NAMES
NAMED
NAMESPACE
NATIONAL
NATURAL
NCHAR
NEXT
NO
NODE
NONE
NO_
NOPARAM
NOT
NOTHING
NOTIFY
NOW
NOWAIT
NO_
NO_
NORELY
NTH_
NTILE
NULL
NULLCOLS
NULLIF
NULLS
NUMERIC
NVARCHAR
O
OBJECT
OCTET_
OF
OFF
OFFLINE
OFFSET
OFFSETS
OIDS
ON
ONLINE
ONLY
OPEN
OPERATOR
OPTIMIZATION
OPTIMIZE
OPTIMIZER
OPTIMIZER_
OPTION
OPTIONS
OPTIONALLY
OR
ORDER
ORDERED_
ORPHAN
OUT
OUT_
OUTER
OUTFILE
OVER
OVERLAPS
OVERLAY
OWNED
OWNER
P
PACK_
PAIRED
PARSER
PARQUET
PARTIAL
PARTITION
PARTITION_
PARTITIONING
PARTITIONS
PASSING
PASSWORD
PASSWORD_
PARSER
PAUSE
_
PERCENT_
PERCENTILE_
PERCENTILE_
PERIODIC
PERSISTED
PI
PIPELINE
PIPELINES
PIVOT
PLACING
PLAN
PLANS
PLANCACHE
PLUGINS
POOL
POOLS
PORT
POSITION
POW
POWER
PRECEDING
PRECISION
PREPARE
PREPARED
PRESERVE
PRIMARY
PRIOR
PRIVILEGES
PROCEDURAL
PROCEDURE
PROCEDURES
PROCESS
PROCESSLIST
PROFILE
PROFILES
PROGRAM
PROMOTE
PROXY
PURGE
Q
QUARTER
QUERIES
QUERY
QUERY_
QUEUE
QUOTE
R
RADIANS
RAND
RANGE
RANK
READ
_
READS
REAL
REASSIGN
REBALANCE
RECHECK
RECORD
RECURSIVE
REDUNDANCY
REDUNDANT
REF
REFERENCE
REFERENCES
REFRESH
REGEXP
REINDEX
RELATIVE
RELEASE
RELOAD
RELY
REMOTE
REMOVE
RENAME
REPAIR
_
REPEAT
REPEATABLE
_
_
REPLACE
REPLICA
REPLICATE
REPLICATING
REPLICATION
DURABILITY
REQUIRE
RESOURCE
RESOURCE_
RESET
RESTART
RESTORE
RESTRICT
RESULT
_
RETRY
RETURN
RETURNING
RETURNS
REVERSE
REVOKE
RG_
RIGHT
RIGHT_
RIGHT_
RIGHT_
RLIKE
ROLE
ROLES
ROLLBACK
ROLLUP
ROUND
ROUTINE
ROW
ROW_
ROW_
ROW_
ROWS
ROWSTORE
RULE
RPAD
_
RTRIM
RUNNING
S
S3
SAFE
SAVE
SAVEPOINT
SCALAR
SCHEMA
SCHEMAS
SCHEMA_
SCROLL
SEARCH
SECOND
SECOND_
SEC_
SECURITY
SELECT
SEMI_
_
SENSITIVE
SEPARATOR
SEQUENCE
SEQUENCES
SERIAL
SERIALIZABLE
SERIES
SERVICE_
SERVER
SESSION
SESSION_
SET
SETOF
SECURITY_
SHA
SHA1
SHA2
SHARD
SHARDED
SHARDED_
SHARE
SHOW
SHUTDOWN
SIGMOID
SIGN
SIGNAL
SIMILAR
SIMPLE
SITE
SIGNED
SIN
SKIP
SKIPPED_
SLEEP
_
SMALLINT
SNAPSHOT
_
_
SOFT_
SOME
SONAME
SPARSE
SPATIAL
SPATIAL_
SPECIFIC
SPLIT
SQL
SQL_
SQL_
SQL_
SQL_
SQLEXCEPTION
SQL_
SQL_
SQL_
SQL_
SQLSTATE
SQLWARNING
SQRT
SSL
STABLE
STANDALONE
START
STARTING
STATE
STATEMENT
STATISTICS
STATS
STATUS
STD
STDDEV
STDDEV_
STDDEV_
STDIN
STDOUT
STOP
STORAGE
STR_
STRAIGHT_
STRICT
STRING
STRIP
SUBDATE
SUBSTR
SUBSTRING
SUBSTRING_
SUCCESS
SUM
SUPER
SYMMETRIC
SYNC_
SYNC
_
_
_
_
SYNCHRONIZE
SYSID
SYSTEM
T
TABLE
TABLE_
TABLES
TABLESPACE
TAGS
TAN
TARGET_
TASK
TEMP
TEMPLATE
TEMPORARY
TEMPTABLE
_
TERMINATE
TERMINATED
TEST
TEXT
THEN
TIME
TIMEDIFF
TIME_
TIME_
TIMEOUT
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIMEZONE
TIME_
TINYBLOB
TINYINT
TINYTEXT
TO
TO_
TO_
TO_
TO_
TO_
TO_
TO_
TO_
TRACELOGS
TRADITIONAL
TRAILING
TRANSFORM
TRANSACTION
_
TREAT
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNC
TRUNCATE
TRUSTED
TWO_
_
TYPE
TYPES
U
UCASE
UNBOUNDED
UNCOMMITTED
UNDEFINED
UNDO
UNENCRYPTED
UNENFORCED
UNHEX
UNHOLD
UNICODE
UNION
UNIQUE
_
UNIX_
UNKNOWN
UNLISTEN
_
UNLOCK
UNLOGGED
UNPIVOT
UNSIGNED
UNTIL
UPDATE
UPGRADE
UPPER
USAGE
USE
USER
USERS
USING
UTC_
UTC_
UTC_
_
V
VACUUM
VALID
VALIDATE
VALIDATOR
VALUE
VALUES
VARBINARY
VARCHAR
VARCHARACTER
VARIABLES
VARIADIC
VARIANCE
VAR_
VAR_
VARYING
VECTOR_
VERBOSE
VERSION
VIEW
VOID
VOLATILE
VOTING
W
WAIT
_
WARNINGS
WEEK
WEEKDAY
WEEKOFYEAR
WHEN
WHERE
WHILE
WHITESPACE
WINDOW
WITH
WITHOUT
WITHIN
_
WORK
WORKLOAD
WRAPPER
WRITE
X
XACT_
XOR
Y
YEAR
YEAR_
YES
Z
ZEROFILL
ZONE
Last modified: July 20, 2022