Hi!

To see the a list of objects that depends on your table for example.
In the left pane with the Table double click on the table that you
want to modify and select the tab "Dependencies" and there you will
have a list with the object thats depends on your table.


Regards, Stefan

On 4/29/05, Tim Gahnström <tim.gahnstrom@...> wrote:
> 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
> 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?
>
> Tim
>
>
> Yahoo! Groups Links
>
>
>
>
>