Is there an easy way to delete multiple tables in the database without dropping the database and recreating it? In this case we have over 100 to remove.
I am happy enough to remove all user tables and reimport the needed data but can't touch any of the database security settings.
Best Answer
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.