SQLite is an Open Source Database which is embedded into Android. SQLite is available on every Android device.
SQLite require very less memory at runtime (approx. 250 KByte).
Enternally SQLite database creates filesystem so this may be slow, Therefore it is recommended to perform database operations inside the AsyncTask class.
The package android.database contains all general classes for working with databases. android.database.sqlite contains the SQLite specific classes.
If your application creates a database, this database is by default saved in the directory DATA/data/APP_NAME/databases/FILENAME.
How to see SQLite database inside Android
Download SQLite Browser:
Download Link : http://code.google.com/p/droidexplorer/downloads/detail?name=sqlitebrowser_200_b1_win.zip&can=2&q=