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 vote98 views1 answer
Copy Table from SQL to CSV
SQL
3 votes103 views2 answers
How to list columns for particular tables in postgresql
SQL
6 votes92 views4 answers
Mysql update set
SQL
0 vote105 views1 answer
Query only first letter string
SQL
0 vote97 views1 answer
Sql last 7 days
SQL
-1 vote100 views1 answer
Io
SQL
0 vote106 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote131 views1 answer
Isnull in sqlite
SQL
2 votes146 views1 answer
Tsql copy table
SQL
0 vote113 views1 answer
Postgresql linux password
SQL