Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Unable to Find Dependencies to Drop Table

Patrick_Ting_1Patrick_Ting_1
in General Discussion
Regarding this error: DROP TABLE a.b; Error: [Vertica][VJDBC](3128) ROLLBACK: DROP failed due to dependencies [Vertica][VJDBC]Detail: Cannot drop Table b because other objects depend on it SQLState: 2BV01 ErrorCode: 3128 How do you enumerate all dependencies for table b? I've already tried looking for entries in system tables table_constraints and foreign_keys, but I don't see any relevant entries.

Comments

  • Daniel_LeybovicDaniel_Leybovic
    Hi! To see all dependencies(projections) you can use in query: select * from projections where anchor_table_name = 'A_TABLE'; or select export_objects('','A_TABLE'); https://my.vertica.com/docs/6.1.x/HTML/index.htm#1294.htm
    HINT: Use DROP ... CASCADE to drop the dependent objects too.
  • Patrick_Ting_1Patrick_Ting_1
    Thanks for the pointers. I didn't see anything obvious besides the super projections, so I decided to just drop with cascade and it worked. It would be much better if the error message at least reported the 1st dependency found so I know what to manually drop without the use of cascade.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.