Hi All, I noticed a difference in the output that pragma table_info gives for tables and views. It seems, that not null conditions aren't properly returned for views:
create table atab ( id int not null primary key, withnulls text, withoutnulls text NOT NULL ); create view aview as select * from atab; pragma table_info(atab); pragma table_info(aview); Please notice that table_info(aview) returns always 0 in the not_null column, whereas the same column is properly reported for pragma table_info(atab). Is this known and intentional? Is there plans to correct that behavior? I have to deal with any database schema, wanted to use table_info as a means to extract the column definitions of views. I understand that reporting the pk-ness of a column is likely to be intentionally not correct for views. Thomas _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
