On 22 Mar 2019, at 9:34pm, Peng Yu <pengyu...@gmail.com> wrote: > There are cid's for each table. Is there a way to use "select" with > cid's instead of their names?
In recent versions of SQLite you can use the result from pragma_table_info('test') as if it is a table. So you can do SELECT select * from pragma_table_info('test') WHERE cid=1; Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users