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 vote265 views1 answer
How to get data from 2 database
SQL
0 vote252 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote277 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote265 views1 answer
Ver usuarios mysql
SQL
4 votes251 views1 answer
Create table if not exist in sqlite
SQL
7 votes259 views1 answer
Sql server convert string to date
SQL
5 votes281 views1 answer
Mysql add user with all privileges
SQL
0 vote264 views1 answer
Sql check for null and empty string
SQL
0 vote285 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote239 views1 answer
Go install mysql
SQL