If you need to create a primary key that is a composite key using SQL,the key may be defined when the table is created using the CREATE TABLE statement.

Question

Quizplus · Accepted Answer

When creating a table using SQL, you can define a primary key that is a composite key by including multiple columns in the CREATE TABLE statement. For example:

CREATE TABLE myTable (
   column1 INT,
   column2 INT,
   column3 VARCHAR(255),
   PRIMARY KEY (column1, column2)
);

This creates a table with a primary key that consists of both column1 and column2.

If You Need to Create a Primary Key That Is