Home >

On this page

AX2617

Deleting a table

Deleting a table removes that table and its data from the database. This action cannot be undone.

NOTES:  

  • You cannot delete a table if another table is dependent on that table. If the table is a lookup source for another table, you must first edit the other table to point to a different lookup source.

  • You can delete a document reference table (Save Type 3) if it is no longer needed. However, unless the source file is also deleted or configured differently, the table will be recreated the next time a save-to-database is executed in the file.

  • If the table is the target of a drill-through definition, that drill-through definition will also be deleted when the table is deleted. The software does not provide a warning before performing this deletion. If the drill-through definition should not be deleted, then you must modify the definition to point to a different table before deleting the original table.

Only administrators and users with the Administer Tables permission can delete a table in the Desktop Client. Users with the Administer Picklist permission can delete picklist tables, but only by using the Web Client Table Manager.

To delete a table:

  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 delete, then right-click that table and click Delete.

You are prompted to confirm that you want to delete the table.