In this article I am going to explain how create a database in an Android application and how create table in the database.

·         Start a new project named TableDemo.

·         Open res/layout/main.xml and insert the following:

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android=""

·         Open the Activity file and insert the following code:

import java.util.Locale;

import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;

public class DatabaseActivity extends Activity {

        private String table_name="StudentInfo";

     public void onCreate(Bundle savedInstanceState) {
         SQLiteDatabase db;

         // create or open database file
         db = openOrCreateDatabase("Test.db" , SQLiteDatabase.CREATE_IF_NECESSARY,


         // creating table in database
         db.execSQL("CREATE TABLE IF NOT EXISTS "+table_name+" " +
                         "( sid INTEGER PRIMARY KEY AUTOINCREMENT," +
                         " name TEXT" +
                         " age INTEGER" +
                         " course TEXT ); ");

         // capture element id from layout
         TextView txtView=(TextView)findViewById(;
         txtView.setText("Table created");

·         Run the application.

The output should look like below:

Create Table in Android Database

TextView display a message Table created when you run an application.

·         Check the created table in the adb shell:

In order to check the tables and database information from the database, you can use adb shell provided by Android SDK:

1)      Run the cmd (command prompt).

2) Go to the following location: d:\android-sdk_r13-windows\android-sdk-windows\platform-tools> (you have to user your own location).

3)      Type adb shell and press enter, a # symbol will display.

4)      Type sqlite3 /data/data/ [package name]/databases/database-name Test.db) and press Enter.
For e.g. sqlite3 /data/data/

5)      Then type .tables in order to see the table present in the database.

6)      It will show you a list tables present in the database.

Thanks for reading this article. I think this will help you a lot.

  Modified On Mar-23-2018 02:18:53 AM

Leave Comment