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
Find largest table in mysql database
SQL
0 vote273 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote222 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote236 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote249 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote238 views2 answers
Sql use not in
SQL
4 votes366 views6 answers
Laravel jwt
SQL
0 vote220 views1 answer
Mysql connection with sqlalchecmy
SQL
1 vote246 views1 answer
Oracle undo usage per session
SQL
0 vote242 views2 answers
Create-toys-table-with-toy_name-column
SQL