AX2618

Editing table properties

You can edit existing tables to change certain table properties, and to add, edit, or delete columns and other table features (such as aliases, sequences, and calculated fields). The following restrictions apply:

• The table name cannot be edited. If you really need to change a table name, you can clone the table and give it a new name, and copy the table data to the new table.

• The table classification can only be changed if the table does not belong to a table type, and the structure of the table is compatible with the new classification. For example, you cannot change a data table to a reference table if it has multiple key columns. Additionally, it is not possible to change the classification of KPI tables.

• Once a table has been created, it is not possible to change the index scheme to Large Table (or from Large Table to something else).

• If you want to change the table type of a table to a different table type, the table must be compatible with the new table type. You can always change a table type to None.

The ability to edit table properties is limited to administrators and to users with the following security permissions: the global Administer Tables permission or the Allow changing table structure permission for individual tables. Users with the Administer Picklists permission can edit picklist table properties, but only when using the Web Client Table Manager.

To edit table properties:

1. On the Axiom tab, in the Administration group, click Tables > Table Administration > Manage Tables.

   The Axiom Explorer dialog opens, with the focus on the Table Library.

   NOTE: If you are using an Axiom packaged product, you can access this feature from the Admin tab. Click System Browser to open Axiom Explorer, then navigate to the Table Library.

2. In the Table Library folder, navigate to the table that you want to edit.

   You can view the list of tables by folder, by table, or by table type. By default, tables are displayed by folder. If you want to change the display, right-click the Table Library folder and then use the View menu to select the desired view.

3. Right-click the table and then click Edit table structure.

4. In the Edit Table dialog, edit the table as desired.

   • On the Table Properties tab, you can edit the description and several optional properties. See Table properties.
   • On the Columns tab, you can add or delete columns, and edit column properties. See Managing table columns.
   • On the Aliases tab, you can add, edit, or delete aliases. See Managing column aliases.
   • On the Sequences tab, you can add, edit, or delete sequences. See Managing column sequences.
   • On the Calculated Fields tab, you can add, edit, or delete calculated fields. See Managing calculated fields.
   • On the Data Conversion tab, you can enable and configure data conversion, or disable conversion. See Configuring conversions for a table.
5. Click Save.

TIP: You can also access the Edit Table dialog through the Table Library listed on the Tables menu. Navigate to the table that you want to edit, then choose Edit table structure.