--- In firebird-support@yahoogroups.com, "frische_brise2003"
<juemu@w...> wrote:

> Hi all,
>
> I've created a view 'XYZ'.
>
> When I try to drop it I get the following
> error message:
>
> unsuccessful metadata update.
> cannot delete.
> COLUMN PK_CONTACT.
> there are 1 dependencies.
>
> But I'm sure, there are no other objects
> depending on this view.
>
> Any ideas?

select rdb$dependent_name from rdb$dependencies
where rdb$depended_on_name='XYZ'

?


Best regards,
Alexander