Deleting custom tables

Administrators can delete custom tables that are no longer needed. For example, delete a table from an application that is under development because the business requirements change.

A table is custom if an administrator created it and it is not part of a system upgrade or plugin activation. Custom table names always begins with u_, or x_ for scoped tables.

Warning: You cannot delete base system tables. If you inadvertently delete such a table, it is automatically recreated when you upgrade an instance.

You cannot delete a table that has associated tables that extend from it.

You must first delete all records in the table before you delete the table itself. If you do not first delete the records, errors can result on the parent table if it references the records. Deleting the records removes any references from the parent table. To learn more, see delete the records in the table.

• Delete a custom table
  If you no longer need a custom table, you can delete it after you delete all the records in the table.
• Delete all records from a table
  You may decide to delete all the records on a table without deleting the table itself. For example, the administrator may want to delete all incidents on a test instance without deleting the incident table itself.

Parent Topic:Managing tables and indexes