On 20 Oct 2013, at 6:11pm, Bogdan Ureche <bogdan...@gmail.com> wrote:
> Sorry, I misread your reply In your defence, my writing was ambiguous. > You are correct. In your scenario, after step > 3 the trigger references a table that no longer exists. As an alternative one could ALTER TABLE RENAME the table to something else, then create a new table with the old name. Now, should the trigger refer to the old table or the new table ? > A similar issue > exists with foreign keys. Right. SQLite is literal: it stores the commands as text, and executes what the text says. Some other SQL engines are semantic: they interpret the text when it is entered, and do what it meant when the interpretation was done. I don't think SQL92 specifies one or the other. But it does mean that anyone trying to write a GUI Manager for SQLite has to understand what it does and why. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users