---
title: "Create Table in Android Database"  
description: "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 name"  
author: "Chris Anderson"  
published: 2011-10-27  
updated: 2020-03-04  
canonical: https://www.mindstick.com/articles/795/create-table-in-android-database  
category: "android"  
tags: ["android"]  
reading_time: 3 minutes  

---

# Create Table in Android Database

In this article I am going to [explain](https://www.mindstick.com/forum/159699/what-is-a-compilation-error-in-dot-net-core-explain-with-an-example) how create a database in an [Android application](https://www.mindstick.com/articles/1653/creating-libraries-for-android-applications) and how create [table in the database](https://www.mindstick.com/forum/157515/what-are-ddl-triggers-create-a-trigger-to-prevent-a-user-to-delete-a-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="http://schemas.android.com/apk/res/android"
     android:orientation="vertical"
     android:layout_width="fill_parent"
     android:layout_height="fill_parent">
<TextView
        android:id="@+id/txtView"
        android:layout_marginLeft="100dp"
         android:layout_width="fill_parent"
         android:layout_height="wrap_content"
         android:text="@string/hello"/>
</LinearLayout>
```

· Open the Activity file and insert the following code:

```
import java.util.Locale;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.widget.TextView;

public class DatabaseActivity extends Activity {

        private String table_name="StudentInfo";

     @Override
     public void onCreate(Bundle savedInstanceState) {
         super.onCreate(savedInstanceState);
         setContentView(R.layout.main);
         SQLiteDatabase db;

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

                                                                               null);
         db.setVersion(1);
         db.setLocale(Locale.getDefault());
         db.setLockingEnabled(true);

         // 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(R.id.txtView);
         txtView.setText("Table created");
    }
}
```

· Run the application.\

##### The output should look like below:

![Create Table in Android Database](https://www.mindstick.com/mindstickarticle/1f25b4d7-7957-4695-be35-c785e6344cd2/images/74b61fbd-22bd-47fc-9097-93de6ab73bbf.png)

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/com.android.databaseDemo/databases/Test.db

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.

\

---

Original Source: https://www.mindstick.com/articles/795/create-table-in-android-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.