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 vote266 views1 answer
Mysql offset from bottom
SQL
0 vote312 views1 answer
Drop unique
SQL
5 votes336 views1 answer
Sql add column after another
SQL
0 vote321 views1 answer
How to input data as id in database sql c#
SQL
9 votes315 views4 answers
How to create new user and database postgresql in ubuntu
SQL
1 vote320 views1 answer
Mysql event last execution
SQL
1 vote309 views1 answer
Mysql limit results to 10
SQL
2 votes325 views2 answers
Postgres drop column if exists
SQL
0 vote336 views1 answer
Sql update subtract value
SQL
1 vote317 views1 answer
Python clean sql string
SQL