---
title: Reserved Words
slug: reserved-words
description: Reserved words are keywords in Ocient® that are specific words that the database can interpret as SQL syntax or unquoted identifiers.
docTags: 
createdAt: Fri Apr 10 2026 19:50:43 GMT+0000 (Coordinated Universal Time)
updatedAt: Fri Apr 10 2026 20:04:00 GMT+0000 (Coordinated Universal Time)
---

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 | 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

# Related Links

[SQL Reference](https://docs.ocient.com/sql-reference)
