title: Android Room persistance library. Drop Table
body: <p>I need to know how to "DROP FROM Table" using Room Persistence Library.</p>
  
  <p>I already know that we can delete all the rows using the method:</p>
  
  <pre><code>@Query("DELETE FROM table")
  void deleteAll();
  </code></pre>
  
  <p>However, what I need is deleting the whole table. This is because of my primary_key is an autoincrement column, so using the previous code, it is not rested.</p>
  
  <p>I already read answers about this topic in the next links:</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/53805597/reset-auto-increment-in-androids-room-library">Reset auto-increment in Android's Room library</a></li>
  <li><a href="https://stackoverflow.com/questions/50878734/android-room-reset-auto-generated-key-on-each-app-run">Android Room - reset auto generated key on each app run</a> </li>
  </ul>
  
  <p>However, I can't believe that this library doesn't provide an easier way to do this, regardless of the reason or use.</p>