December 8th, 2004, 10:46 AM
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??!
December 8th, 2004, 01:11 PM
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