How do you set primary key in table?
Answers
Answered by
3
We generally set a primary key to the field that can be uniquely identified from record to record.
To insert it...when you are the design view to create the field names...
select the he field u want to set as primary key
a yellow arrow appears in the left margin of the field ..click on it a drop down appears
and u can select the option primary key.
And the primary key is set!!
Hope it helped u!!
To insert it...when you are the design view to create the field names...
select the he field u want to set as primary key
a yellow arrow appears in the left margin of the field ..click on it a drop down appears
and u can select the option primary key.
And the primary key is set!!
Hope it helped u!!
Answered by
9
●Open the database that you want to modify.
●In the Navigation Pane, right click the table in which you want to set the primary key and, on the shortcut menu, click Design View.
●Select the field or fields that you want to use as the primary key.
Similar questions