Question

What is a primary key? How do you create a composite primary key?​

Answer 1

Answer:

⭐ A primary key that is made by the combination of more than one attribute is known as a composite key. In other words we can say that: Composite key is a key which is the combination of more than one field or column of a given table. It may be a candidate key or primary key.

️‍️

⭐ Ways to create Composite primary key:-

✍️

• Via Enterprise Manager (SSMS).

• Right Click on the Table you wish to create the composite key on and select Design.

• Highlight the columns you wish to form as a composite key.

• Right Click over those columns and Set Primary Key.

Answer 2

Explanation:

Right Click on the Table you wish to create the composite key on and select Design.

Right Click on the Table you wish to create the composite key on and select Design.Highlight the columns you wish to form as a composite key.

Right Click on the Table you wish to create the composite key on and select Design.Highlight the columns you wish to form as a composite key.Right Click over those columns and Set Primary Key.

A primary key that is made by the combination of more than one attribute is known as a composite key. In other words we can say that: Composite key is a key which is the combination of more than one field or column of a given table. It may be a candidate key or primary key.