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 vote316 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
1 vote316 views1 answer
Generate random data postgresql
SQL
1 vote326 views1 answer
Base64 encode sql server
SQL
0 vote314 views1 answer
C# add a textbox in mysql select
SQL
0 vote347 views1 answer
Insert query return id mysql
SQL
0 vote301 views1 answer
Database get 10 user aleatory
SQL
0 vote299 views1 answer
Joins vs includes
SQL
0 vote322 views1 answer
How to get nth number in sql
SQL
0 vote336 views1 answer
Create a plsql object
SQL
3 votes309 views2 answers
Postgresql remove not null constraint
SQL