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

1 vote284 views1 answer
Postgresql can you have null foreign key
SQL
0 vote211 views1 answer
Fix sqlite3 ruby on rails
SQL
2 votes206 views1 answer
Insert from table tsql
SQL
0 vote216 views2 answers
Php convert dbf to mysql
SQL
1 vote205 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote233 views1 answer
Acutal month year
SQL
3 votes221 views3 answers
Restart mysql mac
SQL
11 votes221 views1 answer
Oracle view ddl
SQL
25 votes230 views6 answers
Import database mysql command line
SQL
0 vote209 views1 answer
Mysql jdbc timezone
SQL