.db to .sql

Problems with WiFi, SQLite ,Bluetooth, WiMax, Proxies, etc...

.db to .sql

Postby zahidalinaqvi » Thu Aug 06, 2009 3:17 pm

i have a database file abcd.db now i just want to see the structure of the database like how many tables are there and what type of data it has.
User avatar
Posts: 35
Joined: Mon Aug 11, 2008 8:54 am
Location: Jaipur India


Postby nmc » Thu Aug 06, 2009 6:51 pm

You're asking about doing this on android with abcd.db being a sqlite database?

Getting the tablenames:
select name from sqlite_master where type='table'

Getting the structure of a table:
select sql from sqlite_master where name='<NameOfTheTable>'
Senior Developer
Senior Developer
Posts: 154
Joined: Thu Nov 27, 2008 8:30 pm
Location: Germany


Return to Networking & Database Problems

Who is online

Users browsing this forum: No registered users and 2 guests