Re: [sqlite] UNIQUE in PRAGMA Table_Info

2011-09-10 Thread Petite Abeille
On Sep 10, 2011, at 9:41 AM, Thomas Baumann wrote: > can you please add a column to the result of PRAGMA Table_Info() that > indicates this column is UNIQUE? > > Just like the notnull column. > > I don't want to parse the whole sql string for this property only. > > Or have I missed

Re: [sqlite] UNIQUE in PRAGMA Table_Info

2011-09-10 Thread Igor Tandetnik
Thomas Baumann wrote: > can you please add a column to the result of PRAGMA Table_Info() that > indicates this column is UNIQUE? What should be reported for this table definition: create table FancyUnique(a, b, c, d, unique(a, b), unique(c, d) ); -- Igor Tandetnik

[sqlite] UNIQUE in PRAGMA Table_Info

2011-09-10 Thread Thomas Baumann
Hello, can you please add a column to the result of PRAGMA Table_Info() that indicates this column is UNIQUE? Just like the notnull column. I don't want to parse the whole sql string for this property only. Or have I missed something? Greetings and thanks in advance. Thomas B.