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 vote171 views1 answer
Oracle apex run 404
SQL
0 vote169 views1 answer
Mysql backup certain tables workbench
SQL
0 vote182 views1 answer
GROUP BY postgres
SQL
18 votes173 views4 answers
Mysql current date between two dates
SQL
0 vote176 views1 answer
Selecting from a view SQL
SQL
0 vote174 views1 answer
Sql server concat null
SQL
0 vote175 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote171 views3 answers
Mysqli count down
SQL
5 votes181 views4 answers
Change auto increment mysql
SQL
22 votes186 views3 answers
How to join three tables in sql using joins
SQL