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

Reply via email to