Q11. How can you set the primary key for a table in Base?
Ans. In this question, we are using the Stud_Database database that contains Student an Faculty tables. Perform the following steps to set the primary key in the Student table:
- Right-click the field of the table in which you want to set a primary key. In our case, we have right-clicked the Stud_RollNo field. A context menu appears.
- Select the Primary Key check box from the context menu.
The primary key is set for the selected field in the table.