What is composite primary key in SQL?

Question

Can any explain the composite primary key in SQL?

Answer 1

Composite primary key or Composite key is a combination of two or more than two columns to uniquely identify the records of a table but if it is taken individually does not guarantee uniqueness.

You can specify the composite key as follows:

CREATE TABLE Table_Name 

(COLUMN_1, DATA_TYPE_1,  

COLUMN_2, DATA_TYPE_2,  

…….

PRIMARY KEY (COLUMN_1, COLUMN_2, ...));  

If you wish to learn SQL from Industry experts then check out this SQL Course by Intellipaat that provides instructor-led training, and also certification.