James wrote:

>Hi guys
>
>I have a view where I want to drop it, but an error message appears
>saying it can't perform this action cause there is 1 dependencies.
>Using the IBExpert, I don't see any object that depends on that view? Is
>there something wrong?
>
>Please help.
>
>
>regards,
>james
>
>

Sometimes I got this message on a table that I thought that has no
dependencies (FK's, Triggers, SP's, etc.)... Buty I have CHECK
constraints on some columns, after dropping those constraints I could
drop the table.

On your case, a view, I don't think it's apply, did you have a check on
rdb$dependencies ?

select * from rdb$dependencies where rdb$depended_on_name = 'your_view_name'


see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br