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

3 votes103 views2 answers
Mysql time
SQL
1 vote114 views1 answer
Postgresql transaction discard all
SQL
0 vote112 views1 answer
Top 3 salary in sql
SQL
0 vote72 views1 answer
Expose db in virtualbox
SQL
2 votes110 views1 answer
Oracle virtual column
SQL
0 vote112 views1 answer
Mysql subdate
SQL
1 vote106 views1 answer
Get rows affected mysql python
SQL
0 vote104 views1 answer
Mysql Error Code: 1005
SQL
0 vote114 views1 answer
Prodection ready postgres database step by step
SQL
0 vote129 views1 answer
Command line mysql xampp
SQL