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 votes127 views1 answer
Mysql sysdate
SQL
2 votes121 views1 answer
Oracle sql drop column if exists
SQL
-1 vote144 views2 answers
Mysql get day of week
SQL
1 vote130 views1 answer
Cross schema query oracle 2 users
SQL
0 vote126 views1 answer
Resulting Query
SQL
0 vote130 views1 answer
Oracle query archivemode
SQL
0 vote248 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
7 votes135 views2 answers
Create index mysql
SQL
2 votes136 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
1 vote131 views1 answer
What is in condition in sql
SQL