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.

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>'