Subject Re: [firebird-support] Can't drop view due to dependency on non-existent object
Author Ann W. Harrison
On 2/8/2011 4:55 PM, Rick Debay wrote:
> I'm trying to drop a view, and keep getting the error that there is a
> dependency. I can't find one, but DBW claims it's associated with a
> view that was dropped long ago. I try to drop that view, but FB says it
> doesn't exist.
>
> What are all the system table columns where a dependency might be
> squirreled away?
>

Have a look at RDB$VIEW_RELATIONS ...


Cheers,

Ann