Option to TRUNCATE tables

Hi @cybercr33p,

Why not ?? Do you have a specific use case? In my case, when I want to empty a whole table, it’s probably because I really don’t need that table at all anymore.

I would like to avoid adding too many icons and options, users get easily confused, so that’s why. Of course, I could add an option for additional features as well.

For example wp_actionscheduler_logs which can become huge if you use actionscheduler a lot, for example plugins that sync products with facebook, etc. Also the wp_actionscheduler_actions would be nice to have an option to delete entries that are not in “pending” status, such as “failed”, “complete”.

You can also add these features in the paid version, for example to autoclean these two tables with entries older than 7 days.

That would be part of the free version ??

Indeed, it’s a good idea. I will add the Auto/Manual/Never dropdown like the one I have for the Post Types. Then I will make sure the Actions are using the right icons: the trash icon will be to delete a set of data (in this case, it will delete a certain number of data older than x days), and a close/cross icon will be to delete the whole amount (in this case, it will drop the table).

It’s part of my todo list!