Empty or Delete Custom Tables

This tool affects only custom database tables that start with a prefix defined in  wp-config.php file ($table_prefix variable). Other tables in the database that do not have that prefix and WP core tables are not affected by it. 

  • Deleting (dropping) tables completely removes them from the database
  • Emptying (truncating) removes all content from them, but keeps the table structure intact

Running the tool will NOT remove any WP Reset Database snapshots you have.

A list of custom database tables is retrieved by running SHOW TABLE STATUS SQL command and then iterating through tables to pick ones that start with $wpdb->prefix but are not on the list of default WP tables; commentmeta, comments, links, options, postmeta, posts, term_relationships, term_taxonomy, termmeta, terms, usermeta, users.

Depending on the chosen tool, custom tables (if any) are either emptied with TRUNCATE TABLE or deleted with DROP TABLE.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us