>TERSE QUESTION >Is the sqlite3_table_column_metadata() SQLite C API function also wrapped >by the APSW Python Library? >http://www.sqlite.org/capi3ref.html#sqlite3_table_column_metadata
I don't see it presently. >Or is there another way to get the primary key without scraping the SQL >(string) field in the SQLite3 master table? http://www.sqlite.org/pragma.htm See the following PRAGMA's for retrieving table/index/foreign key info. They return data in standard table format and work notwithstanding the support of the API and should work just fine with any interface to the SQLite library (even from the command line tool): PRAGMA table_info PRAGMA index_list PRAGMA index_info PRAGMA foreign_key_List _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users