Truncate a SQLite table if it exists?

by

It is the two step process:

  1. Delete all data from that table using:

    Delete from TableName

  2. Then:

    DELETE FROM SQLITE_SEQUENCE WHERE name="TableName";

More Related Contents:

  1. How do I unlock a SQLite database?
  2. “Insert if not exists” statement in SQLite
  3. How to delete or add column in SQLITE?
  4. How to use ROW_NUMBER in sqlite
  5. Android – Pulling SQlite database android device
  6. How to get Top 5 records in SqLite?
  7. Insert new column into table in sqlite?
  8. How do you enable LIMIT for DELETE in SQLite?
  9. SQLite Schema Information Metadata
  10. How to create custom functions in SQLite
  11. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  12. is there a limit to the size of a SQLite database?
  13. How to generate all dates between two dates
  14. SQLITE_BUSY The database file is locked (database is locked) in wicket
  15. Does it matter what extension is used for SQLite database files?
  16. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  17. How do I DROP a constraint from a sqlite (3.6.21) table?
  18. Sqlite over a network share [closed]
  19. SQLite table constraint – unique on multiple columns
  20. Are there any reserved words in SQLite?
  21. Modify a Column’s Type in sqlite3
  22. Case sensitive and insensitive like in SQLite
  23. SQLite accent-insensitive search
  24. How to have an automatic timestamp in SQLite?
  25. svn cleanup: sqlite: database disk image is malformed
  26. SQLite for large data sets?
  27. Integration Testing Entity Framework code first with in-memory database
  28. How to get the number of rows of the selected result from sqlite3?
  29. How to get the last index of a substring in SQLite?
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment