There are situation when we need to maintain(store) data at our application level, this is mainly done when we try to execute functionalists at offline mode. So for these kind scenarios android sdk has provide us class known as SQLiteOpenHelper with the help of which we can maintain a database.

The very first step is to learn how to create a table. And before that you should know what is Table and Columns . It is very basic terminology of sqlite. So briefly we can say that table is a structure with various columns in which we store the data of a particular data type. Lets take up an example a very common example I must say :) . Suppose you need to save an employee data, here I'm just saving the name of employee, his salary, his designation. You can have more information as per your requirement.

So first we need to declare the following before we move ahead :

// Table name
private static String EMPLOYEE_TABLE = "Employee_Table";

// Columns names
private static String EMPLOYEE_NAME = "Employee_Name";
private static String EMPLOYEE_DESIGNATION = "Employee_Designations";
private static String EMPLOYEE_SALARY = "Employee_Salary"; 

Now how to write a query for creating a table :-

// Query for creating table for employee
        String employeeTableQuerry = "create table " + EMPLOYEE_TABLE + "( " + BaseColumns._ID
                + " integer primary key autoincrement, " + EMPLOYEE_NAME + " text, "+ EMPLOYEE_DESIGNATION + " text, "+ EMPLOYEE_SALARY + " text not null);";
        Log.d("employeeData", "onCreate: " + employeeTableQuerry);

Specifically the exact implementation in android you will find below :-

 private class DataBaseHelp extends SQLiteOpenHelper{

// Table name
private static String EMPLOYEE_TABLE = "Employee_Table";

// Columns names
private static String EMPLOYEE_NAME = "Employee_Name";
private static String EMPLOYEE_DESIGNATION = "Employee_Designations";
private static String EMPLOYEE_SALARY = "Employee_Salary"; 
        @Override
        public void onOpen(SQLiteDatabase db) {
            super.onOpen(db);
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            // Query for creating table for employee
        String employeeTableQuerry = "create table " + EMPLOYEE_TABLE + "( " + BaseColumns._ID
                + " integer primary key autoincrement, " + EMPLOYEE_NAME + " text, "+       EMPLOYEE_DESIGNATION + " text, "+ EMPLOYEE_SALARY + " text not null);";
        Log.d("employeeData", "onCreate: " + employeeTableQuerry);

               db.execSQL(employeeTableQuerry);
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        }
    }

Hope this will help you in starting up with the sqlite database in android and creating a table inside, go through it and please feel free to ask if you have any query. :)

Visit my next blog to learn How to Insert data in android SQLITE table