Book a Demo

Author Topic: Unticking Primary Key flag leaves behind "empty" constraint  (Read 3014 times)

SCAIAndre

  • EA Novice
  • *
  • Posts: 11
  • Karma: +0/-0
    • View Profile
Unticking Primary Key flag leaves behind "empty" constraint
« on: January 13, 2016, 12:44:39 am »
Hi,

when setting an attribute of a database table as a primary key, EA automatically generates a primary key constraint under "Constraints" of that table. The attribute is selected in the "Columns" property of the constraint.

But when I untick the primary key flag, the attribute is removed from the "Columns" property of the constraint (which is now empty).

I'd rather expect that the constraint is removed then.

Why does this not happen? I have an inconsistent constraint now, having no columns. Wouldn't it make more sense to automatically remove a primary key constraint, when the last column is removed from it?

This bothers me for a long time :)

TIA
Andre