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, trackname text, artistid integer, constraint FK_track_artistid_artist_artistid foreign key (artistid) references artist(artistid) ); Running the following query: PRAGMA foreign_key_list(track) Does not display the name of the foreign key constraint as expected: "FK_track_artistid_artist_artistid" sqlite manager 0.6.8 add-on for firefox 3.6.13 windows 7 ultimate x64 Thank you. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
