There is a bug in the IB dependency tracking.

You can safely delete that particular record from the RDB$DEPENDENCIES table
if you're sure that there are none left... (also check computed fields).

I wonder -- did you ever use that column in a Foreign Key definition?

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

> 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
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>