Subject cannot find dependency
Author Duilio Foschi
I use Firebird (v. WI-T1.0.0.679).

I want to drop colum ID from table MV_LI, but get the message "there is one
dependency".

I cannot find this dependency in my SQL code and this is blocking my work.

Marathon says that the dependency name is DB$717.

When I look into RDB$DEPENDENCIES I find 4 equal records like this:

rdb$dependent_name rdb$depend_on_name rdb$field_name rdb$dependent_type
DB$717 MV_LI ID 2

rdb$depended_on_type
0

What does it mean ?

How can I delete the column ?

TIA

Duilio Foschi