Notes

30 Dec 2013

SQLite3 – Add or Remove NOT NULL Constraint on Existing Table Column

By Alex Bouchard under programming 

ALTER TABLE YourTable RENAME TO OldTable;
CREATE TABLE YourTable (/* old cols with new requirements */);
INSERT INTO YourTable SELECT * FROM OldTable;
DROP TABLE OldTable;
VACUUM;
.q

Source