Dica para quem usa o console do MySQL.

Deleção de multiplas tabelas:

1) Fazer um select com o prefixo das tabelas utilizando concat.

mysql> SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_name like 'wp_sf_%';
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| statement                                                                                                                                                                                                                                                                           |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DROP TABLE wp_sfdefpermissions,wp_sfforums,wp_sfgroups,wp_sflog,wp_sfmembers,wp_sfmemberships,wp_sfmessages,wp_sfmeta,wp_sfnotice,wp_sfpermissions,wp_sfpostratings,wp_sfposts,wp_sfroles,wp_sfsettings,wp_sftagmeta,wp_sftags,wp_sftopics,wp_sftrack,wp_sfusergroups,wp_sfwaiting; |
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

2) Note que o comando foi gerado acima, agora basta efetuar o drop table.

mysql> DROP TABLE wp_sfdefpermissions,wp_sfforums,wp_sfgroups,wp_sflog,wp_sfmembers,wp_sfmemberships,wp_sfmessages,wp_sfmeta,wp_sfnotice,wp_sfpermissions,wp_sfpostratings,wp_sfposts,wp_sfroles,wp_sfsettings,wp_sftagmeta,wp_sftags,wp_sftopics,wp_sftrack,wp_sfusergroups,wp_sfwaiting;
Query OK, 0 rows affected (0.01 sec)

3) Confirmando:

mysql> SHOW TABLES like 'wp_sf_%'; Empty set (0.00 sec)

Abraços.