On Thu, 29 Apr 2010 09:55:19 +0200, Andrea Galeazzi <[email protected]> wrote:
>Is it possible to change check constraints? Not with ALTER TABLE. Create a new table with the correct constraints, fill it with INSERT ... SELECT ..., DROP the old one, rename the new table to the old name with ALTER. You may have to recreate indexes and triggers. Usually it's a good idea to write a few "load test data into new schema", or even "unload data from old schema / load data into new schema" scripts when you start a project. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
