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
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
"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
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
&
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
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
___
6 matches
Mail list logo