>Hi
>
>I need to remove a lot of tables from a database. How can I do this without having to select each one and delete it individually.
>
>I'm looking for some sort of wildcard selection.
>
>Thanks
>
>
>Nick

This is not a well-known fact, but you can drop them by one DROP command

http://beyondrelational.com/modules/1/justlearned/388/tips/9120/you-can-drop-multiple-tables-using-single-drop-statement.aspx