On 16 May 2011, at 3:44am, romtek wrote: > Secondly, if I executed the above SQL code, what would happen to triggers, > etc. that are associated with the original table?
I suspect that's a major reason why SQLite doesn't support DROP COLUMN: it has to check for things that might depend on the column and refuse to DROP if it finds anything. The answer to your question can be found only by reading the documentation for TRIGGERs, etc.. FOREIGN KEYs will, for instance, be a problem. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
