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

13 votes141 views2 answers
Sql join
SQL
4 votes183 views2 answers
Sql select except null
SQL
3 votes134 views2 answers
Create schema postgres
SQL
0 vote127 views2 answers
Sqlite unix timestamp
SQL
1 vote126 views1 answer
Drop table if exists oracle
SQL
0 vote118 views1 answer
Database springboot
SQL
0 vote131 views1 answer
Oracle exchange subpartition
SQL
1 vote146 views1 answer
How to show index type in postgresql
SQL
3 votes126 views2 answers
Oracle sql truncate table
SQL
0 vote131 views1 answer
Reading from right to left from string find first special characters in sql
SQL