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

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 (
     col1 integer not null primary key,
     col2 integer
);

adding a column may well wind up with something like:

CREATE TABLE a (
     col1 integer not null primary key,
     col2 integer, col3 integer
);

... note how it's been tacked on to the same line as col2. That can make 
it easy to miss when reading through a pile of SQL.

_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users