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 vote321 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote287 views1 answer
Check for directory in bash
SQL
7 votes282 views1 answer
Oracle set sequence value to max(id)
SQL
5 votes294 views3 answers
Select tables from mysql database
SQL
10 votes297 views2 answers
Show tables in schema oracle
SQL
0 vote329 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
3 votes296 views2 answers
Sql select data from last week
SQL
-2 votes283 views3 answers
Sqlite reset autoincrement
SQL
0 vote321 views1 answer
Alter domain sql
SQL
0 vote292 views1 answer
Mysql conf.d exampel
SQL