A fast way to delete all records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stefano - 02 Dec 2007 13:20 GMT

Hi all,
in a Sql Server Compact Edition 3.5 database I just need to delete all the
records in a table, is there any way faster than execute a DELETE FROM
statement, or more practical than deleting the table and recreate it?
UnfortunatelyTRUNCATE TABLE is not supported...is there another way?

Reply to this Message

ErikEJ - 02 Dec 2007 13:46 GMT

No, there is no alternatives to the two methods you decribe. If you want to
keep the
old table, you can use sp_rename.

Signature

Erik Ejlskov Jensen, Mobile App Dev MCTS
Check out my SQL Compact blog at
http://erikej.blogspot.com

> Hi all,
> in a Sql Server Compact Edition 3.5 database I just need to delete all the
> records in a table, is there any way faster than execute a DELETE FROM
> statement, or more practical than deleting the table and recreate it?
> UnfortunatelyTRUNCATE TABLE is not supported...is there another way?

Reply to this Message