Re: [sqlite] Difference in pragma table_info between tables and views

On Wed, 14 Aug 2013 10:03:53 +0200, Thomas Krueger wrote: >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

[sqlite] Difference in pragma table_info between tables and views

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