SQL Reference

Reserved Words

Overview

Keywords in

 cannot be used where they could be interpreted as SQL syntax. When they are used in this context, they are considered reserved words. These words have special meanings in the database. In order to use them in your naming, you must surround the word with double quotes.

You can find these words in the virtual table sys.reserved_words.

A

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

B

BAD_DATA_TARGET | BALANCE | BETWEEN | BUCKET

C

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

D

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

E

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

F

FALSE | FILTER | FIRST | FIX | FOLLOWING | FOR | FROM | FULL | FUNCTION

G

GDC | GRANT | GROUP

H

HAVING

I

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

J

JOIN

L

LAST | LATERAL | LEFT | LIKE | LIMIT | LOAD | LOADERS

M

MATRIX | MLMODEL | MOVE

N

NODE | NOT | NULL | NULLS

O

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

P

PARTITION | PIPELINE | PRAGMA | PRECEDING | PROCEDURE

Q

QUARANTINE | QUERY

R

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

S

SAMPLE | SEGMENT | SEGMENTSIZE | SELECT | SEMI | SERVICE | SET | SHOW | SIMILAR | SKIP_CACHE | SKIP_CACHE_READ | SKIP_CACHE_WRITE | SLEEP_IN_OPTIMIZER | SOME | SOURCE | SSO INTEGRATION | START | STATS | STOP | STORAGESPACE | STREAMLOADER_PROPERTIES | STREAMLOADERS | SUMMARY_STATS | SYSAUTH

T

TABLE | TABLE_WITH_ROWIDS | TAG | TASK | THEN | TO | TO_IP | TRACE | TRUE | TRUNCATE | TUPLE | TYPE

U

UNBOUNDED | UNION | USE | USER | USING

V

VIEW

W

WHEN | WHERE | WITH

Z

ZSTD

Special Character Keywords

_R | _C

Related Links

SQL Reference