# DDL Reserved Words

> The mcocomp DDL compiler recognizes reserved words that have operational meaning and consequently cannot be used in the schema definition as class or field names. (Please see the SQL Reserved Words page for a list of reserved words for the SQL compiler.)

> The following are reserved words recognized by the DDL compiler:

> abs | acos | add | all | and
> any | as | asc | ascending | asin
> atan | atomic | autoid | avg | between
> bigint | binary | bit | blob | boolean
> by | calculator | cascade | case_insensitive | cast
> ceil | char | checkpoint | class | collate
> compact | constraint | cos | count | create
> database | date | datetime | decimal | declare
> delete | delete_all | desc | descending | direct
> distinct | distrib | distributed | domain | double
> drop | escape | event | except | exists
> exp | float | float | floor | for
> foreign | from | group | hash | having
> history | ignore_case | in | index | inner
> insert | int | integer | intersect | into
> is | join | key | left | length
> like | limit | list | local | log
> longint | longvarbinary | longvarchar | lower | max
> min | minus | natural | nchar | new
> nonatomic | nonunique | not | now | nstring
> null | numeric | OID | oid | on
> optional | or | order | outer | packed
> persistent | primary | real | ref | reference
> references | right | select | sequences | set
> signed | sin | smallint | some | sqrt
> string | struct | substr | sum | sysdate
> table | tan | time | time | timestamp
> tinyint | to | transient | tree | TTL_clock_time
> TTL_count | unicode | union | unique | unsigned
> unsigned | update | upper | userdef | using
> values | varbinary | varchar | vector | voluntary
> wchar | where | wstring | FALSE | TRUE