Question

How to remove primary key in table? ​

Answer 1

Answer:

In Object Explorer, expand the table that contains the primary key and then expand Keys.

Right-click the key and select Delete.

In the Delete Object dialog box, verify the correct key is specified and click OK

Answer 2

Answer:

1. In object explorer right click the table with primary key and click design.

2. in the tabke grid, right click the row with the primary key and choose remove primary key to setting.

3. on the file menu click save table name.