Jay A. Kreibich <j...@kreibi.ch> wrote:
>   You can't add a CHECK constraint to an existing table.

You should be able to do it by directly updating sqlite_master table:

http://old.nabble.com/Any-workarounds-suggestions-for-dropping-a-not-null-constraint--td27439289.html

It would probably be prudent to first make sure that all existing data does 
satisfy the constraint.
-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to