#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2004
    Posts
    3
    Rep Power
    0

    delete all items from database


    hi,this is probably fairly simple but im fairly new to delphi and need help asap!!!
    I can delete specific items from a database table ok, but need to know how to delete all entries in all the tables.
    can u help me please??!

    thanks
  2. #2
  3. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,648
    Rep Power
    4248
    You could do one of the following:
    1. Drop the database and recreate it from a script.
    2. Stop the database server, copy over blank database files and then restart the database server.

    These are probably the fastest methods.
    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