Skip to Content
Nov 17 at 10:35 AM

What are the effects of changing the key field in a database table?



Assuming I have a Database/Transparent Table named ZICEVEHICLES. Currently, I can create multiple entries of CAR ID with single car engine ID.


Current situation:

Ford Fiesta - 1.0 Ecoboost( Accepted entry)

Ford Fiesta - 1.5 Ecoboost( Accepted entry)

Ford Fiesta - 3.2 Duratorq Diesel.( Accepted entry)

Ford Ranger Raptor - 3.2 Duratorq Diesel (I tried adding this but since the Car Engine ID is a Key Field, the entry wont be accepted)

It is possible to change the key field into Car ID so I can create like this?

Ford Fiesta - 1.0 Ecoboost

Ford Focus - 1.0 Ecoboost

Ford Ranger Raptor - 1.0 Ecoboost

Ford Raptor - 1.0 Ecoboost

Lastly, this is a custom table and is being used by other custom program. How do I check if changing the keyfield of a transparent table will affect other programs?


image.png (9.0 kB)