>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>
- Mrinal.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
