Skip to main content

ERD generator

  • March 25, 2014
  • 2 replies
  • 14 views
Navin_C
Forum|alt.badge.img+2
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

    2 replies

    Curtis_1
    Forum|alt.badge.img
    • Curtis_1
    • Participating Frequently
    • March 27, 2014

    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.

    Navin_C
    Forum|alt.badge.img+2
    • Navin_C
    • Author
    • Participating Frequently
    • March 27, 2014
    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement