Modify Sqlite Table Column NOT NULL to NULL

Question

I am looking for something similar to this but I'm using sqlite3. I have tried:

sqlite> UPDATE JOBS SET JOB_TYPES = NULL;

But I got "constraint failed". Am I doing it the correct way?

I want to change the current "NOT NULL" to "NULL".

Answer 1

SQLite has almost no ALTER TABLE support.

The easiest method to change a table is to create a new table, and copy the data over:

CREATE TABLE Jobs2(..., JOB_TYPES NULL, ...);
INSERT INTO Jobs2 SELECT * FROM Jobs;
DROP TABLE Jobs;
ALTER TABLE Jobs2 RENAME TO Jobs;