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

3 votes144 views2 answers
Update Query in SQL Server
SQL
0 vote195 views1 answer
Oracle show running job
SQL
1 vote147 views1 answer
Customer using hdfc bank sql query
SQL
0 vote171 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote157 views1 answer
Vagrant mysql downgrade version
SQL
0 vote162 views1 answer
Like date sql server not working
SQL
1 vote148 views2 answers
Pad zero sql server
SQL
0 vote140 views1 answer
Sql constarint
SQL
5 votes146 views3 answers
How to remove unique key constraint in mysql
SQL
6 votes154 views2 answers
Foreign key sqlite3 python
SQL