I have a habit of putting schema definitions in a file that's always safe to read and execute against a DB connection. This means that I DROP some things IF EXISTS and CREATE all things IF NOT EXISTS.
But if I have to ALTER TABLE... there's no IF NOT EXISTS .. equivalent for ALTER TABLE. Funny that, or that I only just noticed this absence. Looking at other SQL databases I see that this is actually a common question/request, and it seems that where this is implemented it looks like this: ALTER TABLE [IF EXISTS] <tbl> ADD COLUMN <col> [IF NOT EXISTS] ..; Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users