Add Or Change Table S Primary Key In. ALTER TABLE AgentIdentification DROP PRIMARY KEY Number ADD PRIMARY KEY AgentId IdIndicator EDIT. MySQL SQL Server Oracle MS Access.
When a primary key contains more than one field it is usually composed of pre-existing fields that taken together provide unique values. Click the Microsoft Office Button and then click Open. Select Design Primary Key.
Select Design Primary Key.
In the table design grid select the field or fields that you want to use as the primary key. Lets create a Table with One Column as a SQL Primary Key. In the Navigation Pane right click the table to which you want to add the primary key and on the shortcut menu click Design View. Open the database that you want to modify.