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 vote255 views1 answer
Sql cheetsheet
SQL
2 votes243 views1 answer
Match in sql server
SQL
6 votes306 views2 answers
Mysql convert timestamp to date
SQL
1 vote259 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
11 votes251 views2 answers
Having clause
SQL
0 vote262 views1 answer
How to find username and password in oracle 18c
SQL
13 votes266 views5 answers
Sql default
SQL
0 vote255 views1 answer
Get foreign table names mysql
SQL
0 vote264 views1 answer
Postgresql import a database of gzip
SQL
0 vote249 views1 answer
How to fetch highest score in minimum time using mysql
SQL