title: How to delete all data in a table in SQL CE?
body: <p>SQL CE does not support TRUNCATE command. To clear a table I have to use DELETE. Is there a quicker/better way to clear the data then the following command?</p>
  
  <pre><code>DELETE FROM FooTable WHERE id !='ABC'
  </code></pre>