[Dagk]

Hi,

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.

[Scorpions4ever]

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.