Add unique index. SQLite3

Question

I need to add a unique field index to an existing table. I made this row:

ALTER TABLE auth_user ADD UNIQUE INDEX (email);

The table and the field are already exist. The error is:

Query Error: near "UNIQUE": syntax error Unable to execute statement

What am I missed? Did it have any specific requirements for SQLite3?

Adriano Carneiro · Accepted Answer · 2011-10-20 13:24:51Z

48

CREATE UNIQUE INDEX IF NOT EXISTS MyUniqueIndexName ON auth_user (email)

Also, read the official manual:

answered Oct 20, 2011 at 13:24

Adriano Carneiro

58.8k12 gold badges94 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1