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

13 votes291 views3 answers
Change data type postgresql
SQL
9 votes300 views3 answers
Postgres make sql dump
SQL
11 votes265 views2 answers
Safe mode off mysql
SQL
1 vote253 views10 answers
Stack overflow
SQL
1 vote226 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote275 views1 answer
How to display value of variable in mysql
SQL
3 votes272 views1 answer
Sql server version query
SQL
3 votes288 views5 answers
Foreign keys
SQL
8 votes384 views2 answers
Select current_timestamp - interval '3 days';
SQL
0 vote266 views1 answer
Soql last week
SQL