Skip to main content
Keywords in are specific words that the database can interpret either as SQL syntax or unquoted identifiers. You cannot use a subset of them, named reserved words, as unquoted identifiers without introducing parsing ambiguities in the database. As a result, when you use these words as an identifier, you must surround the reserved word with double quotes. You can find these words in the sys.reserved_words system catalog table.

​
A

ADD | ALL | ALTER | AND | ANTI | ANY | ARRAY | AS

​
B

BALANCE | BETWEEN

​
C

CACHE | CALL | CANCEL | CASE | CAST | CLASS | CLUSTERING | COLUMN | COLVECTOR | COMMENT | COMPRESSION | COUNT | CREATE | CROSS | CURRENT | CURRENT_DATABASE | CURRENT_DATE | CURRENT_SCHEMA | CURRENT_TIME | CURRENT_TIMESTAMP | CURRENT_USER

​
D

DATA | DATABASE | DEFAULT | DELETE | DISABLE | DISTINCT | DROP

​
E

ELSE | ENABLE | EQUALS | ERROR | EXCEPT | EXECUTE | EXISTING | EXISTS | EXPLAIN | EXPORT | EXTRACT

​
F

FALSE | FIRST | FOLLOWING | FROM | FULL | FUNCTION

​
G

GDC | GRANT

​
H

HAVING

​
I

IGNORE | ILIKE | IN | INDEX | INNER | INSERT | INTERSECT | INTERVAL | INTO | INVALIDATE | IS

​
J

JOIN

​
K

KILL

​
L

LAST | LATERAL | LEFT | LIKE | LOAD | LOADERS

​
M

MATRIX | MLMODEL | MOVE

​
N

NODE | NOT | NULL | NULLS

​
O

OFFSET | ON | OPTION | OPTIONS | ORDER | OUTER | OVER

​
P

PARTITION | PRAGMA | PRECEDING | PROCEDURE

​
R

RANGE | REDUNDANCY | REFRESH | REGEX | REMOVE | RENAME | RESET | REVOKE | RIGHT | ROLE | ROW | ROWS | ROWVECTOR

​
S

SEGMENT | SELECT | SEMI | SERVICE | SET | SHOW | SIMILAR | SOME | START | STOP | STORAGESPACE | SUMMARY_STATS | SYSAUTH

​
T

TABLE | TAG | TASK | THEN | TO | TRACE | TRUE | TRUNCATE | TYPE

​
U

UNBOUNDED | UNION | USE | USING

​
V

VIEW

​
W

WHEN | WHERE | WITH

​
Z

ZSTD SQL Reference
Last modified on September 9, 2026