Mrinal Kant wrote: >> Try: >> PRAGMA [database.]table_info(table-name); > >> ( Kees Nuyt > > Thankyou Kees for the solution > But, I am facing another problem which is as follows: I open an sqlite > db and create a table "trial". pragma main.table_info(trial) shows > correct info. Then I create a temp table with the same name "trial". > Now, pragma main.table_info(trial) shows the info about the temp > table. pragma temp.table_info(trial) also shows info about the temp > table. How do I get the table_info of the main.trial in this case? > > sqlite3.exe trial.sqlite > SQLite version 3.5.2 > Enter ".help" for instructions > sqlite> create table trial (col_main); > sqlite> pragma main.table_info(trial); > 0|col_main||0||0 > sqlite> create temp table trial (col_temp); > sqlite> pragma main.table_info(trial); > 0|col_temp||0||0 > sqlite> pragma temp.table_info(trial); > 0|col_temp||0||0 > sqlite> >
That looks like a bug in sqlite that should be reported at http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
