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 vote317 views1 answer
FindAllBy
SQL
0 vote395 views1 answer
Sql script to remove default from column
SQL
5 votes364 views1 answer
Oracle create table comment
SQL
0 vote404 views1 answer
Add new column in sql with foreign key
SQL
0 vote364 views1 answer
Mysql milliseconds
SQL
0 vote362 views1 answer
Migrations.RunSQL
SQL
0 vote380 views1 answer
Nvl2 syntax
SQL
0 vote341 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote349 views1 answer
Sql server count all tables rows
SQL
0 vote356 views1 answer
Postgress append string in select
SQL