AX2621

Table and column naming requirements

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

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

• Column names are limited to 50 characters by default.

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