# Source: https://docs.oxla.com/sql-reference/sql-statements/keywords.md

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Keywords

In Oxla, **reserved** and **non-reserved** keywords play an important role in SQL syntax and usage.
Reserved keywords are strictly defined by the SQL standard and cannot be used as identifiers, such as table or column names, unless explicitly quoted. These keywords have predefined meanings and are always interpreted as part of the SQL syntax, for example, `SELECT`, `INSERT` and `UPDATE`.

On the other hand, non-reserved keywords have special meanings only in specific context and can be used as identifiers in other situations.  For example, the keyword `DB` is non-reserved, meaning you can use it directly to name a database.

The table below lists all available keywords that you can use in statements:

| <div align="left"> Keyword </div> | <div align="left"> Oxla Status  </div>    |
| --------------------------------- | :---------------------------------------- |
| ABSOLUTE                          | non-reserved                              |
| ACTION                            | non-reserved                              |
| ADD                               | non-reserved                              |
| AFTER                             | non-reserved                              |
| AGGREGATE                         | non-reserved                              |
| ALL                               | reserved                                  |
| ALLOCATE                          | reserved                                  |
| ALTER                             | non-reserved                              |
| ANALYSE                           | reserved                                  |
| ANALYZE                           | reserved                                  |
| AND                               | reserved                                  |
| ANY                               | reserved                                  |
| ANY\_VALUE                        | non-reserved                              |
| ARE                               | reserved                                  |
| ARRAY                             | reserved, requires AS                     |
| ARRAY\_MAX\_CARDINALITY           | non-reserved                              |
| AS                                | reserved, requires AS                     |
| ASC                               | reserved                                  |
| ASENSITIVE                        | non-reserved                              |
| ASSERTION                         | non-reserved                              |
| ASSIGNMENT                        | non-reserved                              |
| ASYMMETRIC                        | reserved                                  |
| AT                                | non-reserved                              |
| ATOMIC                            | non-reserved                              |
| AUTHORIZATION                     | reserved (can be function or type)        |
| AVG                               | non-reserved                              |
| BEFORE                            | non-reserved                              |
| BEGIN                             | non-reserved                              |
| BEGIN\_FRAME                      | non-reserved                              |
| BEGIN\_PARTITION                  | non-reserved                              |
| BETWEEN                           | non-reserved (cannot be function or type) |
| BIGINT                            | non-reserved (cannot be function or type) |
| BIT                               | non-reserved (cannot be function or type) |
| BIT\_LENGTH                       | reserved                                  |
| BLOB                              | non-reserved                              |
| BOOL                              | non-reserved                              |
| BOOLEAN                           | non-reserved (cannot be function or type) |
| BOTH                              | reserved                                  |
| BY                                | non-reserved                              |
| CACHE                             | non-reserved                              |
| CALL                              | reserved                                  |
| CALLED                            | reserved                                  |
| CARDINALITY                       | non-reserved                              |
| CASCADE                           | reserved                                  |
| CASCADED                          | reserved                                  |
| CASE                              | reserved                                  |
| CAST                              | reserved                                  |
| CATALOG                           | non-reserved                              |
| CEILING                           | non-reserved                              |
| CHAR                              | non-reserved                              |
| CHAR\_LENGTH                      | non-reserved                              |
| CHARACTER                         | non-reserved                              |
| CHARACTER\_LENGTH                 | non-reserved                              |
| CHECK                             | reserved                                  |
| CLASSIFIER                        | non-reserved                              |
| CLOB                              | non-reserved                              |
| CLOSE                             | reserved                                  |
| COALESCE                          | reserved                                  |
| COLLATE                           | reserved                                  |
| COLLATION                         | reserved                                  |
| COLLECT                           | non-reserved                              |
| COLUMN                            | reserved                                  |
| COLUMNS                           | non-reserved                              |
| COMMIT                            | reserved                                  |
| CONDITION                         | reserved                                  |
| CONNECT                           | reserved                                  |
| CONNECTION                        | reserved                                  |
| CONSTRAINT                        | reserved                                  |
| CONSTRAINTS                       | non-reserved                              |
| CONTAINS                          | non-reserved                              |
| CONTINUE                          | reserved                                  |
| CONTROL                           | non-reserved                              |
| CONVERT                           | non-reserved                              |
| COPY                              | non-reserved                              |
| CORR                              | non-reserved                              |
| CORRESPONDING                     | reserved                                  |
| COVAR\_POP                        | non-reserved                              |
| COVAR\_SAMP                       | non-reserved                              |
| CREATE                            | reserved                                  |
| CROSS                             | reserved                                  |
| CUBE                              | reserved                                  |
| CUME\_DIST                        | non-reserved                              |
| CURRENT                           | reserved                                  |
| CURRENT\_USER                     | reserved                                  |
| CURRENT\_ROLE                     | reserved                                  |
| CURSOR                            | reserved                                  |
| CYCLE                             | reserved                                  |
| DATABASE                          | non-reserved                              |
| DATABASES                         | non-reserved                              |
| DATALINK                          | non-reserved                              |
| DATE                              | non-reserved                              |
| DATETIME                          | non-reserved                              |
| DAY                               | non-reserved                              |
| DEALLOCATE                        | reserved                                  |
| DEC                               | non-reserved                              |
| DECFLOAT                          | non-reserved                              |
| DECIMAL                           | non-reserved                              |
| DECLARE                           | reserved                                  |
| DEFAULT                           | reserved                                  |
| DEFERRABLE                        | reserved                                  |
| DEFERRED                          | reserved                                  |
| DEFINE                            | non-reserved                              |
| DELETE                            | reserved                                  |
| DELTA                             | non-reserved                              |
| DENSE\_RANK                       | non-reserved                              |
| DEREF                             | non-reserved                              |
| DESC                              | reserved                                  |
| DESCRIBE                          | reserved                                  |
| DESCRIPTOR                        | reserved                                  |
| DETERMINISTIC                     | reserved                                  |
| DIAGNOSTICS                       | reserved                                  |
| DIRECT                            | non-reserved                              |
| DISCONNECT                        | reserved                                  |
| DISTINCT                          | reserved                                  |
| DLNEWCOPY                         | non-reserved                              |
| DLPREVIOUSCOPY                    | non-reserved                              |
| DLURLCOMPLETE                     | non-reserved                              |
| DLURLCOMPLETEONLY                 | non-reserved                              |
| DLURLCOMPLETEWRITE                | non-reserved                              |
| DLURLPATH                         | non-reserved                              |
| DLURLPATHONLY                     | non-reserved                              |
| DLURLPATHWRITE                    | non-reserved                              |
| DLURLSCHEME                       | non-reserved                              |
| DLURLSERVER                       | non-reserved                              |
| DLVALUE                           | non-reserved                              |
| DO                                | reserved                                  |
| DOMAIN                            | non-reserved                              |
| DOUBLE                            | non-reserved                              |
| DROP                              | reserved                                  |
| DYNAMIC                           | non-reserved                              |
| EACH                              | reserved                                  |
| ELEMENT                           | non-reserved                              |
| ELSE                              | reserved                                  |
| EMPTY                             | non-reserved                              |
| END                               | reserved                                  |
| END\_FRAME                        | non-reserved                              |
| END\_PARTITION                    | non-reserved                              |
| EQUALS                            | non-reserved                              |
| ESCAPE                            | reserved                                  |
| EVERY                             | reserved                                  |
| EXCEPT                            | reserved                                  |
| EXCEPTION                         | reserved                                  |
| EXEC                              | reserved                                  |
| EXECUTE                           | reserved                                  |
| EXISTS                            | reserved                                  |
| EXP                               | non-reserved                              |
| EXPLAIN                           | reserved                                  |
| EXTERNAL                          | reserved                                  |
| EXTRACT                           | reserved                                  |
| FALSE                             | reserved                                  |
| FETCH                             | reserved                                  |
| FILE                              | non-reserved                              |
| FILTER                            | reserved                                  |
| FIRST                             | reserved                                  |
| FIRST\_VALUE                      | non-reserved                              |
| FLOAT                             | non-reserved                              |
| FLOOR                             | non-reserved                              |
| FOR                               | reserved                                  |
| FOREIGN                           | reserved                                  |
| FORMAT                            | non-reserved                              |
| FOUND                             | non-reserved                              |
| FRAME\_ROW                        | non-reserved                              |
| FREE                              | non-reserved                              |
| FROM                              | reserved                                  |
| FULL                              | reserved                                  |
| FUNCTION                          | reserved                                  |
| FUSION                            | non-reserved                              |
| GET                               | non-reserved                              |
| GLOBAL                            | reserved                                  |
| GO                                | non-reserved                              |
| GOTO                              | non-reserved                              |
| GRANT                             | reserved                                  |
| GROUP                             | reserved                                  |
| GROUPING                          | reserved                                  |
| GROUPS                            | non-reserved                              |
| HASH                              | non-reserved                              |
| HAVING                            | reserved                                  |
| HINT                              | non-reserved                              |
| HOLD                              | non-reserved                              |
| HOUR                              | non-reserved                              |
| IDENTITY                          | reserved                                  |
| IF                                | reserved                                  |
| ILIKE                             | non-reserved                              |
| IMMEDIATE                         | reserved                                  |
| IMPORT                            | non-reserved                              |
| IN                                | reserved                                  |
| INDEX                             | reserved                                  |
| INDICATOR                         | reserved                                  |
| INITIAL                           | reserved                                  |
| INITIALLY                         | reserved                                  |
| INNER                             | reserved                                  |
| INOUT                             | reserved                                  |
| INPUT                             | reserved                                  |
| INSENSITIVE                       | reserved                                  |
| INSERT                            | reserved                                  |
| INT                               | non-reserved                              |
| INTEGER                           | non-reserved                              |
| INTERSECT                         | reserved                                  |
| INTERSECTION                      | non-reserved                              |
| INTERVAL                          | reserved                                  |
| INTO                              | reserved                                  |
| IS                                | reserved                                  |
| ISNULL                            | non-reserved                              |
| ISOLATION                         | reserved                                  |
| JOIN                              | reserved                                  |
| JSON                              | non-reserved                              |
| JSON\_ARRAY                       | non-reserved                              |
| JSON\_ARRAYAGG                    | non-reserved                              |
| JSON\_EXISTS                      | non-reserved                              |
| JSON\_OBJECT                      | non-reserved                              |
| JSON\_OBJECTAGG                   | non-reserved                              |
| JSON\_QUERY                       | non-reserved                              |
| JSON\_TABLE                       | non-reserved                              |
| JSON\_TABLE\_PRIMITIVE            | non-reserved                              |
| JSON\_VALUE                       | non-reserved                              |
| JSONB                             | non-reserved                              |
| KEY                               | non-reserved                              |
| LAG                               | non-reserved                              |
| LANGUAGE                          | reserved                                  |
| LARGE                             | non-reserved                              |
| LAST                              | reserved                                  |
| LAST\_VALUE                       | non-reserved                              |
| LATERAL                           | reserved                                  |
| LEAD                              | non-reserved                              |
| LEADING                           | reserved                                  |
| LEFT                              | reserved                                  |
| LEVEL                             | non-reserved                              |
| LIKE                              | reserved                                  |
| LIKE\_REGEX                       | non-reserved                              |
| LIMIT                             | reserved                                  |
| LISTAGG                           | non-reserved                              |
| LN                                | non-reserved                              |
| LOAD                              | non-reserved                              |
| LOCAL                             | reserved                                  |
| LOCALTIME                         | reserved                                  |
| LOCALTIMESTAMP                    | reserved                                  |
| LONG                              | non-reserved                              |
| MEASURES                          | non-reserved                              |
| MEMBER                            | non-reserved                              |
| MERGE                             | reserved                                  |
| METHOD                            | non-reserved                              |
| MINUS                             | reserved                                  |
| MINUTE                            | non-reserved                              |
| MODIFIES                          | reserved                                  |
| MODULE                            | non-reserved                              |
| MONTH                             | non-reserved                              |
| MULTISET                          | non-reserved                              |
| NAMES                             | non-reserved                              |
| NATIONAL                          | non-reserved                              |
| NATURAL                           | reserved                                  |
| NCHAR                             | non-reserved                              |
| NCLOB                             | non-reserved                              |
| NEW                               | reserved                                  |
| NEXT                              | non-reserved                              |
| NO                                | reserved                                  |
| NONE                              | non-reserved                              |
| NOT                               | reserved                                  |
| NTILE                             | non-reserved                              |
| NULL                              | reserved                                  |
| NULLIF                            | reserved                                  |
| NULLS                             | reserved                                  |
| NVARCHAR                          | non-reserved                              |
| OCCURRENCES\_REGEX                | non-reserved                              |
| OCTET\_LENGTH                     | non-reserved                              |
| OF                                | reserved                                  |
| OFF                               | non-reserved                              |
| OFFSET                            | reserved                                  |
| OLD                               | reserved                                  |
| OMIT                              | non-reserved                              |
| ON                                | reserved                                  |
| ONE                               | non-reserved                              |
| ONLY                              | reserved                                  |
| OPEN                              | reserved                                  |
| OPTION                            | reserved                                  |
| OR                                | reserved                                  |
| ORDER                             | reserved                                  |
| OUT                               | reserved                                  |
| OUTER                             | reserved                                  |
| OUTPUT                            | reserved                                  |
| OVER                              | reserved                                  |
| OVERLAPS                          | reserved                                  |
| OVERLAY                           | non-reserved                              |
| PAD                               | non-reserved                              |
| PARAMETER                         | reserved                                  |
| PARAMETERS                        | non-reserved                              |
| PARTIAL                           | reserved                                  |
| PARTITION                         | reserved                                  |
| PATTERN                           | non-reserved                              |
| PER                               | non-reserved                              |
| PERCENT                           | non-reserved                              |
| PERCENT\_RANK                     | non-reserved                              |
| PERCENTILE\_CONT                  | non-reserved                              |
| PERCENTILE\_DISC                  | non-reserved                              |
| PERIOD                            | reserved                                  |
| PERMUTE                           | non-reserved                              |
| PLACING                           | non-reserved                              |
| PLAN                              | non-reserved                              |
| PORTION                           | non-reserved                              |
| PRECEDES                          | non-reserved                              |
| PRECISION                         | reserved                                  |
| PREPARE                           | reserved                                  |
| PRESERVE                          | reserved                                  |
| PRIMARY                           | reserved                                  |
| PRIOR                             | reserved                                  |
| PRIVILEGES                        | non-reserved                              |
| PROCEDURE                         | reserved                                  |
| PTF                               | non-reserved                              |
| PUBLIC                            | reserved                                  |
| RANGE                             | reserved                                  |
| READ                              | reserved                                  |
| READS                             | reserved                                  |
| REAL                              | non-reserved                              |
| RECURSIVE                         | reserved                                  |
| REF                               | reserved                                  |
| REFERENCES                        | reserved                                  |
| REFERENCING                       | reserved                                  |
| REGR\_AVGX                        | non-reserved                              |
| REGR\_AVGY                        | non-reserved                              |
| REGR\_COUNT                       | non-reserved                              |
| REGR\_INTERCEPT                   | non-reserved                              |
| REGR\_R2                          | non-reserved                              |
| REGR\_SLOPE                       | non-reserved                              |
| REGR\_SXX                         | non-reserved                              |
| REGR\_SXY                         | non-reserved                              |
| REGR\_SYY                         | non-reserved                              |
| RELATIVE                          | non-reserved                              |
| RELEASE                           | reserved                                  |
| RENAME                            | reserved                                  |
| RESTRICT                          | reserved                                  |
| RESULT                            | reserved                                  |
| RETURN                            | reserved                                  |
| RETURNS                           | reserved                                  |
| REVOKE                            | reserved                                  |
| RIGHT                             | reserved                                  |
| ROLLBACK                          | reserved                                  |
| ROLLUP                            | reserved                                  |
| ROW                               | reserved                                  |
| ROW\_NUMBER                       | non-reserved                              |
| ROWS                              | reserved                                  |
| RUNNING                           | non-reserved                              |
| SAVEPOINT                         | reserved                                  |
| SCHEMA                            | reserved                                  |
| SCHEMAS                           | non-reserved                              |
| SCOPE                             | reserved                                  |
| SCROLL                            | reserved                                  |
| SEARCH                            | non-reserved                              |
| SECOND                            | non-reserved                              |
| SECTION                           | non-reserved                              |
| SEEK                              | non-reserved                              |
| SELECT                            | reserved                                  |
| SENSITIVE                         | reserved                                  |
| SESSION                           | reserved                                  |
| SESSION\_USER                     | reserved                                  |
| SET                               | reserved                                  |
| SHOW                              | non-reserved                              |
| SIMILAR                           | non-reserved                              |
| SIZE                              | non-reserved                              |
| SKIP                              | non-reserved                              |
| SMALLINT                          | non-reserved                              |
| SOME                              | reserved                                  |
| SORTED                            | non-reserved                              |
| SPACE                             | non-reserved                              |
| SPATIAL                           | non-reserved                              |
| SPECIFIC                          | reserved                                  |
| SPECIFICTYPE                      | non-reserved                              |
| SQL                               | reserved                                  |
| SQLCODE                           | non-reserved                              |
| SQLERROR                          | non-reserved                              |
| SQLEXCEPTION                      | non-reserved                              |
| SQLSTATE                          | non-reserved                              |
| SQLWARNING                        | non-reserved                              |
| START                             | reserved                                  |
| STATIC                            | reserved                                  |
| STDDEV\_POP                       | non-reserved                              |
| STDDEV\_SAMP                      | non-reserved                              |
| STRING                            | non-reserved                              |
| SUBMULTISET                       | non-reserved                              |
| SUBSET                            | non-reserved                              |
| SUCCEEDS                          | non-reserved                              |
| SYMMETRIC                         | reserved                                  |
| SYSTEM                            | reserved                                  |
| SYSTEM\_TIME                      | non-reserved                              |
| SYSTEM\_USER                      | reserved                                  |
| TABLE                             | reserved                                  |
| TABLES                            | non-reserved                              |
| TABLESAMPLE                       | reserved                                  |
| TEMPORARY                         | reserved                                  |
| TEXT                              | non-reserved                              |
| THEN                              | reserved                                  |
| TIME                              | non-reserved                              |
| TIMESTAMP                         | non-reserved                              |
| TIMESTAMP\_TRUNC                  | non-reserved                              |
| TO                                | reserved                                  |
| TOP                               | non-reserved                              |
| TRAILING                          | reserved                                  |
| TRANSACTION                       | reserved                                  |
| TRANSLATE                         | reserved                                  |
| TRANSLATE\_REGEX                  | non-reserved                              |
| TRANSLATION                       | non-reserved                              |
| TREAT                             | reserved                                  |
| TRIGGER                           | reserved                                  |
| TRUE                              | reserved                                  |
| TRUNCATE                          | reserved                                  |
| UESCAPE                           | reserved                                  |
| UNION                             | reserved                                  |
| UNIQUE                            | reserved                                  |
| UNKNOWN                           | reserved                                  |
| UNLOAD                            | non-reserved                              |
| UNMATCHED                         | non-reserved                              |
| UNNEST                            | non-reserved                              |
| UPDATE                            | reserved                                  |
| UPPER                             | non-reserved                              |
| USAGE                             | reserved                                  |
| USER                              | non-reserved                              |
| USING                             | reserved                                  |
| VALUES                            | reserved                                  |
| VAR\_POP                          | non-reserved                              |
| VAR\_SAMP                         | non-reserved                              |
| VARBINARY                         | non-reserved                              |
| VARCHAR                           | non-reserved                              |
| VARIADIC                          | reserved                                  |
| VARYING                           | reserved                                  |
| VERSIONING                        | non-reserved                              |
| VIEW                              | reserved                                  |
| VIRTUAL                           | non-reserved                              |
| WHEN                              | reserved                                  |
| WHENEVER                          | reserved                                  |
| WHERE                             | reserved                                  |
| WIDTH\_BUCKET                     | non-reserved                              |
| WINDOW                            | reserved                                  |
| WITH                              | reserved                                  |
| WITHIN                            | reserved                                  |
| WITHOUT                           | reserved                                  |
| WORK                              | reserved                                  |
| WRITE                             | non-reserved                              |
| XML                               | non-reserved                              |
| XMLAGG                            | non-reserved                              |
| XMLATTRIBUTES                     | non-reserved                              |
| XMLBINARY                         | non-reserved                              |
| XMLCAST                           | non-reserved                              |
| XMLCOMMENT                        | non-reserved                              |
| XMLCONCAT                         | non-reserved                              |
| XMLDOCUMENT                       | non-reserved                              |
| XMLELEMENT                        | non-reserved                              |
| XMLEXISTS                         | non-reserved                              |
| XMLFOREST                         | non-reserved                              |
| XMLITERATE                        | non-reserved                              |
| XMLNAMESPACES                     | non-reserved                              |
| XMLPARSE                          | non-reserved                              |
| XMLPI                             | non-reserved                              |
| XMLQUERY                          | non-reserved                              |
| XMLSERIALIZE                      | non-reserved                              |
| XMLTABLE                          | non-reserved                              |
| XMLTEXT                           | non-reserved                              |
| XMLVALIDATE                       | non-reserved                              |
| YEAR                              | non-reserved                              |
| ZONE                              | non-reserved                              |