Documentation Index
Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
Use this file to discover all available pages before exploring further.
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.
ADD | ALL | ALTER | AND | ANTI | ANY | ARRAY | AS
BALANCE | BETWEEN
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
DATA | DATABASE | DEFAULT | DELETE | DISABLE | DISTINCT | DROP
ELSE | ENABLE | EQUALS | ERROR | EXCEPT | EXECUTE | EXISTING | EXISTS | EXPLAIN | EXPORT | EXTRACT
FALSE | FIRST | FOLLOWING | FROM | FULL | FUNCTION
GDC | GRANT
HAVING
IGNORE | ILIKE | IN | INDEX | INNER | INSERT | INTERSECT | INTERVAL | INTO | INVALIDATE | IS
JOIN
KILL
LAST | LATERAL | LEFT | LIKE | LOAD | LOADERS
MATRIX | MLMODEL | MOVE
NODE | NOT | NULL | NULLS
OFFSET | ON | OPTION | OPTIONS | ORDER | OUTER | OVER
PARTITION | PRAGMA | PRECEDING | PROCEDURE
RANGE | REDUNDANCY | REFRESH | REGEX | REMOVE | RENAME | RESET | REVOKE | RIGHT | ROLE | ROW | ROWS | ROWVECTOR
SEGMENT | SELECT | SEMI | SERVICE | SET | SHOW | SIMILAR | SOME | START | STOP | STORAGESPACE | SUMMARY_STATS | SYSAUTH
TABLE | TAG | TASK | THEN | TO | TRACE | TRUE | TRUNCATE | TYPE
UNBOUNDED | UNION | USE | USING
VIEW
WHEN | WHERE | WITH
ZSTD
SQL Reference
