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

2 votes169 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
2 votes157 views1 answer
Mysql cannot delete or update a parent row
SQL
5 votes157 views1 answer
Mysql last day of next month
SQL
1 vote134 views1 answer
Oracle db create new schema
SQL
0 vote136 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote177 views5 answers
Select concat alter table mysql
SQL
5 votes155 views1 answer
Oracle get ddl
SQL
0 vote142 views3 answers
Between keyword sql
SQL
1 vote167 views1 answer
Mysql current running queries
SQL
7 votes131 views3 answers
How to check table name in current database sql
SQL