Microsoft SQL Server Management Studio 2008 deleting multiple user tables
In object explorer, navigate to the database you're interested in. Expand it out and click on the Tables folder. Hit F7 to bring up the Object Explorer Details. Select the tables you want to delete and press the delete key.
Any reason not to do it directly in T-SQL (with DROP TABLE
)? Then it's just a case of creating the appropriate SQL script (quite possibly autogenerating it if you've got a list of the tables you need to delete) and you're away.