>

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


Thanks Sergey

That does the job.