Originally posted by nswan
"delete * .....

should just be

"delete .....

the best way to delete all data is to drop the table, and then re-create it using a stored procedure that you will have already created (u can use stored procedures to create tables).
No offence but that's not such a good approach in a multi-user environment among other reasons.

Other users may get errors when the table is dropped.
I doubt the drop transaction could be rolled back if necessary.
Also there's considerable overhead wifh freeing up the table resources and then recreating them.

IMO much better to stick with the DELETE cmd...