Deleting a User-Defined Table

If you have created a user-defined table in error you can delete it. However, before you delete a table, it is recommended that you use the Check Usage function to make sure there are no areas in the system in which the table is used. If the table is in use, you must modify those objects (e.g. fields, reports, constraints, expressions, forms) before you delete the table. See Checking Pick List, List Item and Field Usage.

Note: You cannot use this method to delete multi-pick tree multi-pick list tables. In order to delete these tables, you must delete the field with the type: Multi Pick Tree or Multi Pick (i.e. MTLIST). Doing so will delete the table and all other related fields (i.e. Parent_ID, Last_Modified etc.). See Managing Form Fields.

Prerequisites: You must have the 'Manage Fields and Tables' role function enabled.

  1. Go to the Fields page and choose a module from the Module drop-down list.
  2. Click Delete Table. The Delete Table dialog is displayed.
  3. Select a table from the Table drop-down list.
  4. Note: Only user-defined metabase tables will appear in the drop-down list.
  5. Click Delete Table. Once the system verifies that the table or its associated fields are not used in forms or pop-up grids, a confirmation message is displayed.
  6. Click Yes to delete the table. The table and all associated fields are deleted.
  • Note: If the table is used in forms or pop-up grids, you will not be able to delete the table. You must first remove the table and/or fields from all forms and pop-up grids and then follow this procedure to delete the table.