composite key in sql code example
Example 1: how to define a composite primary key in sql
CREATE TABLE person(id INT,
name TEXT,
PRIMARY KEY (id, name)
);
Example 2: sql composite key
CREATE TABLE TABLE_NAME
(COLUMN_1, DATA_TYPE_1,
COLUMN_2, DATA_TYPE_2,
....
PRIMARY KEY (COLUMN_1, COLUMN_2, ...));