We mistakenly created a new key as primary key even though we had a perfect candidate key for that.
Now we want to delete that and make the candidate which is already a field on our table the primary key.
Problem we did not want to delete that until is visible via erd.
My question is, can we change a pysical erd to logical one?
We just reverse engineered the database tables and we are using designer 6i.
How can we do that?
thanks
Now we want to delete that and make the candidate which is already a field on our table the primary key.
Problem we did not want to delete that until is visible via erd.
My question is, can we change a pysical erd to logical one?
We just reverse engineered the database tables and we are using designer 6i.
How can we do that?
thanks