"Alex Ousherovitch" <alex.ousherovi...@opentv.com> wrote in message news:5ee1928d06817b4788b64caf1a8517b00325e...@sfo-ex-01.ad.opentv.local > 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
Can't you just drop the table and create a new one? As the table is empty, you won't be losing any data. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users