How to find object dependencies

scherepanovscherepanov ✭✭
in General Discussion

Hi,
I am dropping table, and got an error "Cannot drop Table XXX because other objects depends on it". I do not want to use "cascade" - I want to understand what will be dropped.
I seems to be cannot find system table/view that will list object dependencies.
Can you post here a query that will list object dependencies. Just one level of dependencies would be enough.
I am on v 12.0.4.
Thank you
Sergey

Best Answer

  • SruthiASruthiA Administrator
    Answer ✓

    Do you have any user created projections on that table? if so, could you please try dropping those projections first?

Answers

  • scherepanovscherepanov ✭✭

    @SruthiA
    It appears Vertica tables do not have any dependencies except projections.
    This specific table where I got dependencies error, had only 2 regular superprojections.
    Table is very old, seems to be projections were created using some old syntax. Projections looks same as any other projection, but Vertica want "cascade" in table drop.

  • SruthiASruthiA Administrator

    old syntax projection definition might have caused the problem then

This discussion has been closed.