>>

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

You are welcome