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

4 votes139 views1 answer
Oracle table statistics last analyzed
SQL
3 votes165 views1 answer
Oracle limit user tablespace
SQL
1 vote174 views1 answer
Oracle compile schema
SQL
-1 vote159 views2 answers
Import data from excel to sql server automatically
SQL
21 votes141 views6 answers
Change column in mysql
SQL
1 vote150 views1 answer
Rows to comma separated values in mssql
SQL
7 votes139 views3 answers
Add primary key to database sql
SQL
61 votes1K views6 answers
Mysql add column
SQL
4 votes192 views1 answer
Postgresql change default value
SQL
0 vote148 views1 answer
Add sqlite3 in lumen
SQL