Subject RE: [firebird-support] Disconnect dependencies
Author Alan McDonald
I'm trying to work out how I can easily disable dependencies in my Firebird
database design to allow for a change in the system. For example, I have a
column in a table that is a VARCHAR(500) but I need to make it larger to

But I have a number of stored procedures that refer to this column. I can
change the stored procedures to accommodate the column change, but when I go
to change the actual table column and expand it to this size, it gives an
error stating that the SPs are referring to this field.

Clearly there won't be a problem with this change, but I can't get passed
the FB dependency checks in order to make this change.

What is the best way to handle this scenario?


What admin tool are you using?
In IBExpert - when you arrive at the warning that dependencies exist, you
are offered the creation of a script to drop dependencies, make the mod and
recreate the dependent objects.