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

2020-02-29 Thread Anthony DeRobertis
On 2/27/20 7:03 PM, Andy KU7T wrote: Hi, I use a simple ALTER TABLE ADD COLUMN statement. However, when I use the Sqlite Expert, the DDL is not reflected. One thing to be aware of is that when SQLite adds the column, it often doesn't format it like you'd expect. For example: CREATE TABLE a

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

2020-02-28 Thread Lee Gray
I just tried it in v5.3.5.470 and v5.3.5.472 and it worked fine. From: sqlite-users On Behalf Of Andy KU7T Sent: Thursday, February 27, 2020 6:03 PM To: SQLite mailing list Subject: [sqlite] After column add, what should be done to update the schema? Hi, I use a simple ALTER TABLE ADD COLUMN

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

2020-02-28 Thread David Raymond
"I read somewhere that the DDL is really just a copy of the text when teh table was created" It starts that way, but the ALTER TABLE command will update that string when it runs so that it reflects the new column. Did you commit your changes after the alter table and before looking for the chan

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

2020-02-27 Thread Keith Medcalf
nly a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users On >Behalf Of Andy KU7T >Sent: Thursday, 27 February, 2020 17:03 >To: SQLite mailing list >Subject: [sqlite] After column add, what should be done to update the &

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

2020-02-27 Thread Jean-Christophe Deschamps
Bonjour, 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? I can't re

[sqlite] After column add, what should be done to update the schema?

2020-02-27 Thread Andy KU7T
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 ___