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
--
Regards,
Peng
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
