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 vote324 views1 answer
Utiliser sql ligne de commande
SQL
0 vote281 views1 answer
Sql new line output
SQL
0 vote296 views1 answer
Metada in sql
SQL
0 vote347 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
5 votes313 views1 answer
Ascending order and where in sql
SQL
1 vote311 views2 answers
Mysql spring boot application.properties
SQL
0 vote325 views1 answer
Install sql server in ubuntu 20.04
SQL
0 vote306 views6 answers
Unique key in sql
SQL
1 vote337 views1 answer
Regular expression in sql server
SQL
5 votes331 views4 answers
Select random rows sql
SQL