create Table with text type column - Android Database

Description

create Table with text type column

Demo Code

//package com.java2s;

import android.database.sqlite.SQLiteDatabase;

import android.util.Log;

public class Main {
    public static SQLiteDatabase db;
    public static String detailname = "detaillist";

    public static void createDetailTable() {
        try {//from  w w w. j  a v  a 2s  .co m

            db.execSQL("create table if not exists " + detailname + "("
                    + " _id integer PRIMARY KEY autoincrement, "
                    + " number text," 
                    + " detail text, " 
                    + " memo text);");
        } catch (Exception ext) {
            Log.d("Create table fail", "table make fail");
        }
    }
}

• Previous
• Next

Related Tutorials

• create Table SQL statement
• Get DDL SQL command for create table by class.
• create new Table if it not exists
• Creates table and use smallint as column type
• create Table If Not Exist in SQLiteDatabase