Insufficient or incorrect key column information, updating solutions that affect multiple rows

Once directly through the MMC to copy and paste a table, the background to modify the content prompts: Key column information is insufficient or incorrect, updates affect many lines, after many attempts to finally find a solution!

a resolution that resolves key column information is insufficient or incorrect, and updates the solution that affects multiple rows.

That is, in the Design table function, first the ID index column deleted. Then click Save Table.

Then re-establish a new ID primary key identity field, at which time, you can modify or delete the contents of the table just wrong.

If you want to modify the ID column, it is only the identity of the column and primary key attributes are removed first, the modification is done after the reset on the line.

Don't write and repeat!

Try to solve this problem: Key column information is insufficient or incorrect, updates affect multiple lines