AX2621

Table and column naming requirements

When naming tables and table columns (including alias names), follow these requirements:

  • Table and column names can use standard ASCII alphanumeric characters (a-z, 0-9) and the underscore character. No spaces and no other special characters are allowed.

  • The first character in a table or column name cannot be a number or an underscore. For example, you can have a column named Plan_09 but you cannot have a column named 09_Plan.

  • Columns cannot be named Col#, where # is a number, such as Col1, Col2, etc. Other column name constructions with text and numbers are allowed—for example, BUD1 is valid.

  • Database reserved words should be avoided whenever possible.

  • Table and column names are limited to 50 characters by default. Remember that these names will be used in Axiom queries and Axiom functions to query data, so they should be short yet descriptive.

    NOTE: Systems can be configured to allow longer table and column names if desired. See System configuration settings.

Table and column naming requirements are enforced when a new table or column is saved.