Staffan Tylen wrote:
> I've just found out that the column data returned by PRAGMA table_info does
> not include columns added using ALTER COLUMN ADD COLUMN.

sqlite> create table t(x);
sqlite> pragma table_info(t);
0|x||0||0
sqlite> alter table t add y;
sqlite> pragma table_info(t);
0|x||0||0
1|y||0||0


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to