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
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