title: How to TRUNCATE table with C#
body: <p>How I can truncate a table with c#.</p>
  
  <p>I do this but it doesn't work.</p>
  
  <pre><code>cmd.CommandText = "TRUNCATE TABLE dalbara;";
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p>Visual Studio give me this error: </p>
  
  <blockquote>
    <p>Invalid SQL command, you only can do 'DELETE', 'INSERT', 'PROCEDURE',
    'SELECT' or 'UPDATE'</p>
  </blockquote>
  
  <p>I want to delete and restart all of my access table. With the DELETE command, the autoincrement values, doesn't reset.</p>