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 vote192 views1 answer
Ffeathers express mysql application users login
SQL
1 vote210 views7 answers
Filter
SQL
1 vote239 views1 answer
Sql select row with max date
SQL
4 votes229 views3 answers
Employee name starting with in sql
SQL
0 vote203 views1 answer
Mysql date only no time
SQL
0 vote208 views1 answer
Drop CHECK constraint sql
SQL
0 vote222 views1 answer
Show tables in cassandra cql
SQL
1 vote210 views1 answer
Oracle list constraints
SQL
0 vote208 views1 answer
Can we rollback data that are deleted using DELETE clause?
SQL
0 vote190 views1 answer
Oracle sql date summer time
SQL