| Subject | cannot find dependency | 
|---|---|
| Author | Duilio Foschi | 
| Post date | 2002-03-23T12:39:13Z | 
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
            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