Should I remove the tests from SQLite that prevent triggers in one database from referring to tables in a different database?
Well, I have a couple of triggers in my SQL Server database that refer to tables in another database, though they are on the same server. Obviously, I can see some utility in that. I will admit, however, that if I had to implement the system that uses that scheme in SQLite, then I'd probably have the tables in the same database file, rather than different ones.
