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?
No, there is no alternatives to the two methods you decribe. If you want to keep the old table, you can use sp_rename. -- Erik Ejlskov Jensen, Mobile App Dev MCTS Check out my SQL Compact blog at http://erikej.blogspot.com "Stefano" wrote in message news:%23IevnYONIHA.2268@TK2MSFTNGP02.phx.gbl... > 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?
