Re: [sqlite] Feature Request: PRAGMA foreign_key_list(tableName) should display the name of the foreign key constraint

2011-02-08 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/08/2011 07:55 PM, BareFeetWare wrote: > Currently, I have to run pragma foreign_key_list() for each of my tables, ... Create virtual table(s) and query those as needed. Use the experience to document what worked best, any gotchas and as

Re: [sqlite] Feature Request: PRAGMA foreign_key_list(tableName) should display the name of the foreign key constraint

2011-02-08 Thread BareFeetWare
> On Feb 8, 2011, at 9:07 PM, Rami Abughazaleh wrote: > >> I would like to request that "PRAGMA foreign_key_list(tableName)" display >> the name of the foreign key constraint. Thirded! Or, much better yet, move away from pragmas altogether for introspection, instead using internal tables/views

Re: [sqlite] Feature Request: PRAGMA foreign_key_list(tableName) should display the name of the foreign key constraint

2011-02-08 Thread Petite Abeille
On Feb 8, 2011, at 9:07 PM, Rami Abughazaleh wrote: > I would like to request that "PRAGMA foreign_key_list(tableName)" display > the name of the foreign key constraint. Seconded! :) Unfortunately this doesn't seem to be a priority:

[sqlite] Feature Request: PRAGMA foreign_key_list(tableName) should display the name of the foreign key constraint

2011-02-08 Thread Rami Abughazaleh
Hi. Thank you for sqlite3. I would like to request that "PRAGMA foreign_key_list(tableName)" display the name of the foreign key constraint. For example, For the following table schemas: create table artist(artistid integer primary key, artistname text); create table track(trackid integer,