On 11/23/18, Digital Dog <digitald...@gmail.com> wrote: > I think these changes would not add a lot of code to sqlite and will make > life easier for users.
SQLite remembers the database schema by storing the original CREATE TABLE text in the sqlite_master table. That means the CREATE TABLE is reparsed whenever a new database connection opens the database file. This can lead to compatibility problems if the meaning of a CREATE TABLE statement is somehow affected by PRAGMAs. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users