-- Set result to a text in SSMS
SELECT 'DROP TABLE ' + name
	FROM sys.tables
	WHERE <Your conditions>
-- Copy and run result 

>
>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.
>