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 vote223 views1 answer
Sql convert unix time to date
SQL
2 votes207 views5 answers
Tablespace ORACLE
SQL
0 vote184 views1 answer
Mysql streaming example
SQL
0 vote171 views1 answer
Mysql error 1452
SQL
0 vote181 views1 answer
Sauvegarde complète my sql
SQL
0 vote179 views1 answer
Mysql does collate nopad recognize space
SQL
14 votes221 views3 answers
SQL trim
SQL
31 votes221 views2 answers
Grant all priviledges to mysql user
SQL
11 votes241 views3 answers
Pl sql example
SQL
0 vote194 views1 answer
Create sql table from script inline primary key constraint
SQL