Hello list,
The attempts to add a NOT NULL column on an empty table ALTER TABLE tbl_name ADD COLUMN col_name blob NOT NULL fail with the following error message: Cannot add a NOT NULL column with default value NULL As I understand, many other systems allow it when the table has no records. Is it a bug or a feature in SQLite? Thank you, Alex _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users