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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
