I just tried it in v5.3.5.470 and v5.3.5.472 and it worked fine. From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of Andy KU7T Sent: Thursday, February 27, 2020 6:03 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: [sqlite] After column add, what should be done to update the schema?
Hi, I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite Expert, the DDL is not reflected. Even though the column is created. I read somewhere that the DDL is really just a copy of the text when teh table was created. Is there a way to refresh this? Thanks, Andy _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org<mailto:sqlite-users@mailinglists.sqlite.org> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users<http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users> _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users