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

1 vote156 views1 answer
Create email address from first and last name in sql
SQL
0 vote156 views1 answer
Utiliser sql ligne de commande
SQL
4 votes156 views1 answer
Oracle error compilation line
SQL
0 vote160 views1 answer
Max mysql
SQL
0 vote146 views1 answer
Postgresql create user roles
SQL
1 vote151 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote198 views1 answer
How to check event scheduler status mysql
SQL
0 vote151 views1 answer
Can we rollback deleted data in sql
SQL
1 vote183 views1 answer
Add sequence postgres
SQL
0 vote239 views1 answer
Mysql grant access to one database
SQL