wbrunkca

 Profile Answers by wbrunkca 

• Nov 10th, 2008

 

It removes the clustered index on the table

seemu123

 Profile Answers by seemu123 Questions by seemu123

• Nov 11th, 2008

 

When we create Primary Key By Default it works as Cluster Index. After removal the Primary Key Clustered Index is removed and the particular table does not relate with other table directly.

CattyEyes

 Profile Answers by CattyEyes 

• Nov 11th, 2008

 

If we remove primary key from a table, then that table will store duplicate data which leads to data redundancy which ultimately results in data inconsistency. Answer from::-CattyEyes,  Computer Engineer

HussainExpect

 Profile Answers by HussainExpect 

• Nov 20th, 2008

 

After removing the PK from the table then table will not behave consistantly.

raja_wipro

 Profile Answers by raja_wipro 

• Dec 2nd, 2008

 

After removing the Primary key Redundant data appears in the table. So it will lead to Data inconcistency.

gtotten

 Profile Answers by gtotten 

• May 26th, 2009

 

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

bikash_tamang

 Profile Answers 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 and
2. The table would then allow duplicate data to be inserted causing data corruption.

pravesh28

 Profile Answers by pravesh28 Questions by pravesh28

• Mar 9th, 2010

 

no problem

, 

we use rename operation

and we relace the forigen key inti primary key