Subject Unknown dependencies
Author Tim Gahnström
Sometimes when I (in IBExpert) try to change something I get an error message saying that it cannot be done because there are dependencies on the object in question.

Is there a way to find these dependencies? To my knowledge there shouldn't be any.

In this particular case I am trying to remove a column and get this error message:

"This operation is not defined for system tables.
Unsuccessfull metadata update
Cannot delete
There are 1 dependencies
Changes will be rolled back"

The command IBExpert runs is this:

I have tried restarting the DB and reconnecting to it.

I think this case came about when I changed the field type om the LAST_NAME column from integer to varchar 50. Because in the fields view I correctly see it as varchar 50 but in the Data view IBExpert only allow me to ad integer data.

I don't even know where to look for these mysterious dependencies, I have only one (unrelated) trigger and two indicies on other tables and a few SP but I cant imagine an SP affecting this?