If i created a datase using these statements,



How can i see the Testing database and the tables in it..

Thanks
Nithin

try this

Hello nithin,

you should have a look at this sqlite tutorial http://www.anddev.org/viewtopic.php?t=319

It won't show you the tables, but you can simply query for all datasets in a table:

Regards,
plusminus

hi plusminus,

thanks for your reply. But my question is can we see the tables from terminal mode..

Thanks
Nithin

Hi plusminus,

Now got it.. Thanks

nithin.warier wrote:Hi plusminus,

Now got it.. Thanks

So why don't you share it with us ?

Hi erbedo,

What i did is just gone throught the tutorial what plusminus posted...

Actually, the problem in my case is, i created a table in one structure, later i modified the structure, so its showing, the table "Test" already there. What i did is delete the table from terminal mode using the tutorial.... (Through adb shell, cd data, cd data, cd packagename,
sqlite3 Databasename) then using the statement

drop table tablename;

i did it...

i dont feel its necessary to write what my problem is... now, you specifcally asked, i wrote..

Thanks
Nithin