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

ERD generator

Hello All,

I am trying to do some reverse engineering on Vertica.
I need the ERD diagram from the current Vertica Database.

I have tried SQL power Architect and DBdesigner Fork tool, but both does not relate tables with Primary and Foreign Keys.

I cannot see any links between primary keys and foreign keys in ERD diagram.
Is it Vertica's Default behaviour or any specific tool to be used for seeing this

Thanks

Comments

  • I doubt the Vertica system tables have PK and FK keys defined. So, at best, you'd end up with a diagram of 100+ unconnected tables.


    To further complicate matters, not all joins keys are named the same.  So, it won't be obviously intuitive how to do all the joins.

  • Hi Curtis,

    Thanks for the reply.

    I figured out that DBeaver easily generated an ERD with the relationships in the Tables based on PK-FK constraints.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

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