Book a Demo

Author Topic: cannot change the involved columns of a constraint  (Read 8305 times)

rocketboy2000

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
cannot change the involved columns of a constraint
« on: December 03, 2015, 07:02:14 am »
I know I've done this before but I've plum forgot how to do it and its not obvious from EA messages.

I have a physical data model that I need to adjust to add a foreign key attribute to an entities primary key (make the foreign key identifying). when I attempt this from the "columns and constraints" property dialogue I get the message:

"Cannot change the involved columns of a constraint that is part of a foreign key relationship. Please use the foreign key property window."

I've tried completely deleting the association between the two entities and the foreign key constraint. but I still get the same message which prevents me from adding the attribute to the primary key.

any direction most appreciated.

MMA

  • EA User
  • **
  • Posts: 63
  • Karma: +3/-0
    • View Profile
Re: cannot change the involved columns of a constr
« Reply #1 on: December 03, 2015, 11:34:30 am »
Quote
I've tried completely deleting the association between the two entities ...


There are two kinds of delete:

shallow delete: simply delete the link on the diagram; the relationship is still there. You can bring it back by: Property on the element | Links | select the relationship in the list | context menu | Show Relation

deep delete: the relationship is deleted. (Ctrl + Delete)

Try the deep delete; otherwise contact the support