How do i drop unused tables in my database?

[Adam21]

i need to uninstall a mod that has tables of it residing in database.
i.e the tables all have the prefix starting with dp_
so any queries to drop all table starting with dp_ ?

[Farcaster]

The safest way to handle this would be to drop each of the known tables explicitly using this syntax in the product uninstall code:

$db->query_write("DROP TABLE dp_tablename1");
$db->query_write("DROP TABLE dp_tablename2");
// etc...