How to delete or add column in SQLITE?

by

ALTER TABLE SQLite

SQLite supports a limited subset of ALTER TABLE. The ALTER TABLE command in SQLite allows the user to rename a table or to add a new column to an existing table. It is not possible to rename a column, remove a column, or add or remove constraints from a table.

You can:

  1. create new table as the one you are trying to change,
  2. copy all data,
  3. drop old table,
  4. rename the new one.

More Related Contents:

  1. SQLite how to refer to column name by a query
  2. How do I unlock a SQLite database?
  3. “Insert if not exists” statement in SQLite
  4. SQLite Concurrent Access
  5. System.Data.SQLite Close() not releasing database file
  6. INSERT IF NOT EXISTS ELSE UPDATE?
  7. Sqlite LIMIT / OFFSET query
  8. Set start value for AUTOINCREMENT in SQLite
  9. Update with Join in SQLite
  10. Can I read and write to a SQLite database concurrently from multiple connections?
  11. How do I store and retrieve a blob from sqlite?
  12. ALTER COLUMN in sqlite
  13. SQLite error ‘attempt to write a readonly database’ during insert?
  14. Efficient paging in SQLite with millions of records
  15. Encrypted cookies in Chrome
  16. How delete table inner join with other table in Sqlite?
  17. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  18. How to get a list of column names
  19. sqlite – How to get INSERT OR IGNORE to work
  20. Creating stored procedure and SQLite?
  21. How Scalable is SQLite? [closed]
  22. change sqlite file size after “DELETE FROM table”
  23. How to set unique constraint over multiple columns when any one can be null?
  24. How to have an automatic timestamp in SQLite?
  25. svn cleanup: sqlite: database disk image is malformed
  26. SELECT INTO statement in sqlite
  27. How to display blob value using x’abc’ binary string literal syntax?
  28. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  29. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  30. How to get the number of rows of the selected result from sqlite3?

Leave a Comment