Drop constraints when an entity attribute is removed from the model

By Daan van Hoeke on 26 Jan (4 weeks ago)

When i drop an attribute in the model i get a Database Integrity Suggestion
"Inconsistent database table and entity definitions: column 'OSUSR_8o1_xxx.yyy' exists in database, but there is no corresponding attribute in entity 'xxx'."

But when do an alter table to drop the column i get an error:

The object 'DF__OSUSR_8H1__xxx__753F8AB0' is dependent on column 'yyy'.

So i first have to drop the constraint before being able to drop the column. It would be nice if that was not necessary. 

I do understand why the columns aren't dropped, but i don't think the constraints serve a purpose when the column is no longer present in the model.

This idea has no comments yet. Be the first to comment!