What happens if we remove primary key from SQL table?

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 9th, 2010

No problem, we use rename operationand we relace the forigen key inti primary key

bikash_tamang

 Profile Answers by bikash_tamang Questions by bikash_tamang

• Jul 10th, 2009

Once the primary key is removed two things will happen:1. The clustered index is also removed which decreases performance and2. The table would then allow duplicate data to be inserted causing data corruption.

Answer Question  Select Best Answer