try

select *
from rdb$dependencies
where rdb$dependent_name = 'XXXX'

then

delete
from rdb$dependencies
where rdb$dependent_name = 'XXXX'

Kind Regards,

Robert