When you are using WordPress, it arrives that you need to delete a specific table from your database. For example, to completely delete Yoast plugin traces (after uninstalling it via FTP), you will need to delete some tables such as “yoast_indexable”, “yoast_indexable_hierarchy”, “yoast_migrations”, etc. As it is reported here.
(Make sure to back up your database before deleting anything! In case something went wrong, you can restore it. It is better to be safe than sorry!)
To delete a specific table, follow these steps:
1 – Install the Advanced Database Cleaner Plugin (free plugin).
2 – Go to the “Tables” tab of the plugin.
3 – Search for the tables you want to delete among the list of the tables, then select them.
2- In “Bulk actions”, select “Delete” then click “Apply”. The tables will then be deleted.
If you have hundreds of tables and you cannot manually find those you want to delete, you can use the pro version of the advanced database cleaner plugin to search for specific tables based on their names. To search for specific tables, follow these steps:
1 – Install the pro version of the advanced database cleaner plugin
2 – Go to the “Tables” tab
3 – Type the word you want to search for in the “Search for” text box, then click “Filter”
4 – Select the tables you want to delete from the results, then select “Delete” in “Bulk actions” and click Apply.