>>
>>
>>SELECT 'DROP TABLE ' + name
>> FROM sys.tables
>> WHERE <Your conditions>
>>
>>
>>>
>>>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
--sb--