On Fri, 22 Mar 2019 16:34:20 -0500, 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? Thanks.
>
> $ sqlite3 dbfile <<EOF
> create table test (id integer primary key, value text);
> insert into test (id, value) values (1, 'abc');
> .mode column
> .headers on
> select * from pragma_table_info('test');
> EOF
> cid name type notnull dflt_value pk
> ---------- ---------- ---------- ---------- ---------- ----------
> 0 id integer 0 1
> 1 value text 0 0
Why on earth would you want to do that?
Eric
--
ms fnd in a lbry
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
