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