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