how to set a column as unique indexer on Sqlite

android sqlite unique-index
Mustafa Güven picture Mustafa Güven · Dec 17, 2011 · Viewed 31k times · Source

I have 3 columns (_id, column1, column2) _id column has been set as autoincrement

In database there are some duplicate records, so I want to prevent duplicate records with setting column1 as unique indexer. How do I set a column as unique indexer on sqlite? Or how do I prevent duplicate records?

Answer

Noureddine AMRI picture Noureddine AMRI · Dec 17, 2011

No magic, just SQL:

create table yourtablename (_id  integer primary key autoincrement, column1 text not null unique, column2 text);

_id will not be duplicate in any way because it is primary key, column1 neither because it is unique.

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
How to delete all records from table in sqlite with Android?

My app has two buttons, the first button is for deleting record on user input and the second button is for deleting all records. But when I want to delete data it shows the message "Your application has been forcefully …

Read More
How to store image in SQLite database

In my application I am uploading an image from gallery and I want to store this image in the SQLite database. How do I store a bitmap in the database? I am converting bitmap to a string and saving it …

Read More