On Tue, 17 Jul 2001, Hiroshi Inoue wrote:
> Peter Eisentraut wrote:
> >
> > Alex Pilosov writes:
> >
> > > drop <type> object [RESTRICT | CASCADE]
> > >
> > > to make use of dependency info.
> >
> > That was me. The point, however, was, given object id 145928, how the
> > heck to you know what table this comes from?
> >
>
> Is it really determined that *DROP OBJECT* drops the objects
> which are dependent on it ?
If you used DROP OBJECT CASCADE, yes. That's what CASCADE is saying.
I think the idea is that you can say what happens - delete dependents, or
do something else.
Take care,
Bill