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

5 votes145 views1 answer
Get table columns from sql
SQL
1 vote132 views1 answer
Primary key with prefix sql
SQL
0 vote156 views1 answer
Sql field equals multiple values
SQL
5 votes178 views4 answers
Mysql on duplicate key update
SQL
0 vote162 views1 answer
Sqlite trim
SQL
2 votes133 views1 answer
Set column to not null mysql
SQL
7 votes142 views1 answer
Xampp reset mysql
SQL
0 vote135 views1 answer
Compare two tables to find unmatched records
SQL
7 votes165 views3 answers
Sql server check if temp table exists
SQL
1 vote134 views1 answer
Oracle user last connected
SQL