> 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 IBExpert - click on the dependencies tab.. :-)
> 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
> COLUMN LAST_NAME
> There are 1 dependencies
> Changes will be rolled back"
> The command IBExpert runs is this:
> ALTER TABLE T_CUSTOMERS DROP LAST_NAME
> 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?