Title: Remove Tables From SQL Database Last modified: September 1, 2016 --- # Remove Tables From SQL Database * Resolved [jfcby](https://wordpress.org/support/users/jfcby/) * (@jfcby) * [9 years, 9 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/) * After I deactivated then removed the plugin “All In One WordPress Security and Firewall Plugin” from wp-admin > plugins then go into my cpanel > phpMyAdmin and in my website database the tables beginning with “wpaionwps” are still there. * How do I remove all tables and if needed all remaining files from my wordpress website installation and SQL database? * Thanks for your help. * [https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [9 years, 9 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-7674797) * If you don’t want those tables there you want to uninstall the plugin then you can delete them directly from PHPMyAdmin. (There is a “delete” function in the PHPMyAdmin interface) * [nitrospectide](https://wordpress.org/support/users/nitrospectide/) * (@nitrospectide) * [8 years, 11 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-9267766) * I ran into this as well, but I noticed that when I search the db, I also get 4 occurrences of “aiowps” in the wp_options table. I don’t want to leave those orphaned. * Why doesn’t the plugin remove all of this? * Plugin Contributor [wpsolutions](https://wordpress.org/support/users/wpsolutions/) * (@wpsolutions) * [8 years, 11 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-9268406) * > Why doesn’t the plugin remove all of this? * Main reason is so you don’t lose your aiowps config settings in case you are deactivating and deleting this plugin to upgrade to a newer version. * I will look at maybe putting in another setting in a future version to give user an option of doing a complete deletion of tables and options rows when deleting the plugin. * [nitrospectide](https://wordpress.org/support/users/nitrospectide/) * (@nitrospectide) * [8 years, 11 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-9270023) * Thank you for the reply. That would be very useful. * Actually, WP core should really have a new state for plugins: deactivated, then completely uninstalled. * [thehrisworld](https://wordpress.org/support/users/thehrisworld/) * (@thehrisworld) * [8 years, 11 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-9270171) * Many plugins are now including this as an option. I believe it is better as an option instead of mandatory process during removal as removing and reinstalling plugins seems to correct issues that plugin has with others. If you have a plugin that keeps a history, like WP Statistics, then the database for your stats would be wiped out and you will be restring from zero on all your stats. * [nitrospectide](https://wordpress.org/support/users/nitrospectide/) * (@nitrospectide) * [8 years, 11 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-9270240) * Even if it was in core, nothing says you would have to do the “complete uninstall” step and remove the data. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Remove Tables From SQL Database’ is closed to new replies. * ![](https://ps.w.org/all-in-one-wp-security-and-firewall/assets/icon-256x256. png?rev=2798307) * [All-In-One Security (AIOS) – Security and Firewall](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/) * [Frequently Asked Questions](https://wordpress.org/plugins/all-in-one-wp-security-and-firewall/#faq) * [Support Threads](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/) * [Active Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/unresolved/) * [Reviews](https://wordpress.org/support/plugin/all-in-one-wp-security-and-firewall/reviews/) * 6 replies * 4 participants * Last reply from: [nitrospectide](https://wordpress.org/support/users/nitrospectide/) * Last activity: [8 years, 11 months ago](https://wordpress.org/support/topic/remove-tables-from-sql-database/#post-9270240) * Status: resolved