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