Toad World® Forums

Problem removing Key in Entity Properties


#1

I’m trying to remove a Key that I mistakenly added on the Keys tab for my Entity Properties. I select it and press the Delete button but nothing happens.

How do I remove it?

Darin

keys.jpeg


#2

OK, the problem was the GUIDELINE_ID had the Unique constraint checked. Therefore TDM added the key for the unique constraint… not me.

So when I uncheck Unique the key entry then goes away.

Darin


#3

Just a quick note on this:

As soon as you select Unique for an attribute, an alternate key will be created automatically. It’s not possible to delete the alternate key itselft. You have to clear ‘Unique’ to be able to delete the key. - Just as you did it.

Thanks for raising this topic.

Regards,

Vladka