TexExpander Snippet for dropping the default WordPress tables (without dropping the whole database). Complete with field for adding your table prefix.

gistfile1.txt

DROP TABLE %filltext:name=prefix:default=wp:width=6%_commentmeta;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_comments;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_links;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_options;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_postmeta;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_posts;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_term_relationships;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_term_taxonomy;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_terms;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_usermeta;
DROP TABLE %filltext:name=prefix:default=wp:width=6%_users;