AX2655

Deleting a column from a table

You can delete columns from a table with the following restrictions:

• Key columns can only be deleted if the table has no data. Otherwise, deleting a key column is prevented because it could result in non-unique data.

• Required columns for the table's table type cannot be deleted.

• Columns that belong to a sequence cannot be deleted. You must edit or delete the sequence first.

• If the table is a picklist table or a KPI table, the required columns cannot be deleted.

• If the table uses the Large Table index scheme and the table has data, then no existing columns can be deleted. The overall column structure is fixed once the table has data.

• If the column is controlled by an Axiom packaged product, the column is locked and cannot be deleted.

NOTE: If you delete a column that has an alias, the associated alias will also be deleted.

The ability to delete columns from a table is limited to administrators and to users with the following security permissions: either the global Administer Tables permission, or the Allow changing table structure permission for individual tables.

To delete a column:

1. On the Columns tab of the Edit Table dialog, select the column that you want to delete.

   If you are creating a new table, you can manage columns on the Edit Columns screen of the Create Table wizard.

2. Click Delete Column .

   The column is removed from the list.

3. Click Apply or OK to save your changes.