SQL - Remove Primary Key

GeekInterview.com > Interview Questions > Database > SQL

Go To First | Previous Question | Next Question

SQL | Question 138 of 139

Remove Primary Key

What happens if we remove primary key from SQL table?

Total Answers and Comments: 7

Last Update: July 10, 2009 Asked by: calling.243043

Sponsored Links

Best Rated Answer

—

Submitted by: CattyEyes

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

Above answer was rated as good by the following members:
kishorebabu.yenumula, nakul.v, deepaksp

November 10, 2008 23:39:16

wbrunkca

Member Since: November 2008 Contribution: 1

RE: Remove Primary Key

It removes the clustered index on the table

Is this answer useful? Yes | No

1 0

Overall Rating: +1

November 11, 2008 08:23:03

seemu123

Member Since: May 2008 Contribution: 15

RE: Remove Primary Key

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.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

November 11, 2008 09:11:38

CattyEyes

Member Since: November 2008 Contribution: 1

RE: Remove Primary Key

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

Is this answer useful? Yes | No

2 0

Overall Rating: +2

November 20, 2008 00:50:47

HussainExpect

Member Since: November 2008 Contribution: 2

RE: Remove Primary Key

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

Is this answer useful? Yes | No

0 2

Overall Rating: -2

December 02, 2008 05:56:05

raja_wipro

Member Since: December 2008 Contribution: 2

RE: Remove Primary Key

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 26, 2009 01:11:33

gtotten

Member Since: May 2009 Contribution: 2

RE: Remove Primary Key

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.

Is this answer useful? Yes | No

July 10, 2009 03:14:47

bikash_tamang

Member Since: July 2009 Contribution: 2

RE: Remove Primary Key

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank