SQLite Query creation

Question

I want the the KEYWORD column should contain the unique value in SQLite database. How can I modify following query to do so?

Query is as follows:

  String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
            + KEY_ID + " INTEGER PRIMARY KEY," + KEY_WORD + " TEXT "
            + KEY_KEYCODE + " TEXT" + ")";

Answer 1

Use UNIQUE modifier.

String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
            + KEY_ID + " INTEGER PRIMARY KEY," + KEY_WORD + " TEXT UNIQUE "
            + KEY_KEYCODE + " TEXT" + ")";

Answer 2

Use the UNIQUE keyword:

String CREATE_CONTACTS_TABLE = "CREATE TABLE " + TABLE_CONTACTS + "("
        + KEY_ID + " INTEGER PRIMARY KEY," + KEY_WORD + " TEXT UNIQUE,"
        + KEY_KEYCODE + " TEXT" + ")";