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 bad data target | 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 | end | equals | error | except | execute | existing | exists | explain | export | extract f false | first | fix | following | for | 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 | source | 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 related links https //docs ocient com/sql reference