ALTER COLUMN in sqlite

by

There’s no ALTER COLUMN in sqlite.

I believe your only option is to:

  • Rename the table to a temporary name
  • Create a new table without the NOT NULL constraint
  • Copy the content of the old table to the new one
  • Remove the old table

This other Stackoverflow answer explains the process in details

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. How do I make an UPDATE while joining tables on SQLite?
  5. SQLite Concurrent Access
  6. System.Data.SQLite Close() not releasing database file
  7. Escape single quote character for use in an SQLite query
  8. INSERT IF NOT EXISTS ELSE UPDATE?
  9. Sqlite LIMIT / OFFSET query
  10. Set start value for AUTOINCREMENT in SQLite
  11. How to use ROW_NUMBER in sqlite
  12. Android – Pulling SQlite database android device
  13. SQLite error ‘attempt to write a readonly database’ during insert?
  14. Efficient paging in SQLite with millions of records
  15. Store boolean value in SQLite
  16. SQLite add Primary Key
  17. Encrypted cookies in Chrome
  18. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  19. How to get a list of column names
  20. sqlite – How to get INSERT OR IGNORE to work
  21. Creating stored procedure and SQLite?
  22. How Scalable is SQLite? [closed]
  23. How do DATETIME values work in SQLite?
  24. change sqlite file size after “DELETE FROM table”
  25. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  26. How to set unique constraint over multiple columns when any one can be null?
  27. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  28. SQLite for large data sets?
  29. SQLite database supporting Unicode data
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment