1# SQLite ->
2//if the primary key has only one column,
3//you use the PRIMARY KEY column constraint
4//to define the primary key as follows:
5
6 CREATE TABLE table_name(
7 column_1 INTEGER NOT NULL PRIMARY KEY,
8 ...
9);
10
11// in case primary key consists of two or
12//more columns, you use the PRIMARY KEY table
13//constraint to define the primary as shown in
14//the following statement.
15
16 CREATE TABLE table_name(
17 column_1 INTEGER NOT NULL,
18 column_2 INTEGER NOT NULL,
19 ...
20 PRIMARY KEY(column_1,column_2,...)
21 );