On Sun, Jul 11, 2010 at 02:15:09PM -0400, Igor Tandetnik scratched on the wall: > 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
I figure anyone that wants to go down that path needs to learn it for themselves. There be dragons over yonder. > It would probably be prudent to first make sure that all existing > data does satisfy the constraint. Yes, something the data copy would verify for you. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
