title: Reset AutoNumber(Identity Field) in Database
body: <p>I Use a Sql Server <strong>Compact Edition</strong> Database File For Store the Data in My Windows Application Software.</p>
  
  <p>In this database I have a table with an identity field.</p>
  
  <p>When I insert a record into the Table, the identity code increments automatically. But when I delete all the records from the table, and insert some records again, the identity field doesn't start at 1.</p>
  
  <p>How can I reset this value to 1?</p>