Re: After column add, what should be done to update the schema?

Lee Gray <[email protected]> Fri, 28 Feb 2020 16:04:28 +0000
Newsgroups gmane.comp.db.sqlite.general
Message-ID <1A370B89C093614D8C2AEC1A7DA09B1D01501E0746@MDEX02.morrisdickson.com>
I just tried it in v5.3.5.470 and v5.3.5.472 and it worked fine.

From: sqlite-users <[email protected]> On Behalf Of Andy KU7T
Sent: Thursday, February 27, 2020 6:03 PM
To: SQLite mailing list <[email protected]>
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
[email protected]<mailto:[email protected]>
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users<http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users