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