I double click on an entity
I click the “keys” tab
I have two entries:
PK_CLIENTS PK_CLIENTS CLIENT_ID o
CLIENT_ID CLIENT_ID CLIENT_ID o
The first has the red key marking it as the primary key
The second has nothing under PK.
I don’t know how the second got there, perhaps a left over from changing my mind as to what atttribute would be the key? How do I delete the second? The delete button is greyed out.
When the script is generated it produces:
– Add keys for table CLIENTS
ALTER TABLE “CLIENTS” ADD CONSTRAINT “PK_CLIENTS” PRIMARY KEY (“CLIENT_ID”)
ALTER TABLE “CLIENTS” ADD CONSTRAINT “CLIENT_ID” UNIQUE (“CLIENT_ID”)
Which gives an error.
Message was edited by: cpisz_515