Sqlite unique

sqlite uniue
-------------------------        
CREATE TABLE contacts(
  contact_id INTEGER PRIMARY KEY,
  first_name TEXT,
  last_name TEXT,
  email TEXT NOT NULL UNIQUE
);

Source: sqlitetutorial.net

SQLite UNIQUE

CREATE TABLE contacts(
    contact_id INTEGER PRIMARY KEY,
    first_name TEXT,
    last_name TEXT,
    email TEXT NOT NULL UNIQUE
);
Code language: SQL (Structured Query Language) (sql)

Source: sqlitetutorial.net

Similar codes

0 vote182 views2 answers
Update information in a mysql column
SQL
0 vote197 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote188 views1 answer
Regex mongoose
SQL
4 votes190 views4 answers
Rollback in sql
SQL
2 votes186 views2 answers
Oracle no data found error code
SQL
8 votes184 views2 answers
Alert table name mysql
SQL
1 vote199 views3 answers
How to reset id column in sql server
SQL
-1 vote184 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
14 votes189 views4 answers
Import database through command line
SQL
0 vote163 views1 answer
Sqlite3 not commit
SQL