Reserved Words
Keywords in Ocient® 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 | CHECK | 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 | FIX | 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
SAMPLE | SEGMENT | SELECT | SEMI | SERVICE | SET | SHOW | SIMILAR | SOME | SSO INTEGRATION | 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