Thread: dropping tables

    #1
  1. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Scotland
    Posts
    10
    Rep Power
    0

    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. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,625
    Rep Power
    4247
    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

IMN logo majestic logo threadwatch logo seochat tools logo