On 22 Mar 2019, at 9:34pm, Peng Yu <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
