The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Unable to Find Dependencies to Drop Table
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.
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
select * from projections where anchor_table_name = 'A_TABLE';
orselect export_objects('','A_TABLE');
https://my.vertica.com/docs/6.1.x/HTML/index.htm#1294.htm