|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
October 22nd, 2003, 10:02 AM
|
||||
|
||||
|
dropping tables
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. Last edited by Dagk : October 22nd, 2003 at 10:04 AM.
|
|
#2
October 24th, 2003, 12: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 Puzzle of the Month solved by sizeablegrin, etienne141 and L7Sqr, superior C/C++ programmers of the month
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > dropping tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
