** Disclaimer: This is super dangerous and is for advanced users only. Always make backups! **
n98-magerun.phar db:maintain:clean-tables [-f|--force]
This will start the table TRUNCATEing. If you didn't use -f it will show which tables are about to be nuked and ask you to confirm before continuing.
This module is based on this Stack Overflow answer.