ERD generator

Navin_C

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

Curtis_1

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

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.