Reducing the Primary keys

[Former Member]

Hello,

I created the custom database table - ZPACK, and I created this table with five primary keys. Now, the requirement is to reduce the primary keys from five to three.

And I have the data of 5000 entries in this table. If I uncheck the two primary keys and set them as non primary keys, what will be the impact with the data.

Regards,

dinesh ...........

[Former Member]

Hello,

I created the custom database table - ZPACK, and I created this table with five primary keys. Now, the requirement is to reduce the primary keys from five to three.

And I have the data of 5000 entries in this table. If I uncheck the two primary keys and set them as non primary keys, what will be the impact with the data.

Regards,

dinesh ...........

[Former Member]

Hi

The problem is you risk to lose several records, because now many hits could have the same key.

Only if the field key to be deleted are not used (i.e. they are empty) u shouldn't have any impact.

Max

[Former Member]

Hi Dinesh,

it can cause a loss of data, because no duplicate entries with the same key can occur in a table. And for the entries which differs just in key fields which you are going to mark as non-key, it is not possible to keep all such lines.

Regards,

Adrian

[Former Member]

If you change a field property from Primary key to non-primary key field, there will not be any problem in data wise.but before that you have to check the usage ,functionality etc.. of that field through out all the places where ever it is used.If you feel it does not affect the functionality ,then proceed with change a field property from Primary key to non-primary key field.

[Former Member]

Hi,

It is not at all adviceable to change the primay key, as you do not able to know the dependancy on it, Changing the primay key may crate , data inconsistancy and also you may lost multiple data.

Rani