-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
> 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
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:
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,
4 matches
Mail list logo