October 22nd, 2003, 11:02 AM
I would like to drop a large number of tables in a database. Is there a way of selecting them from a list in enterprise manager or do I have to type the syntax for each table I want to drop? I'm using SQL Server 2000. Thanks.
Last edited by Dagk; October 22nd, 2003 at 11:04 AM.
October 24th, 2003, 01:01 PM
From the enterprise manager, do this:
(a) Select the first table to drop.
(b) Hold down the ctrl key and select the second table to drop.
(c) Continue to hold down the ctrl key and select multiple tables.
(d) After selecting the tables, right click and select Delete from the menu.
(e) You should see a dialog box pop up with all the tables you selected. Within this dialog box, click on the Drop All button to drop all the selected tables.
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
"I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo