As I can't find any ER diagram feature built in with Apex, I want to create one with the SQL statements I executed in order to set up the tables in my Apex Workbench.

I found schemaSpy, which is capable of generating diagrams from many database architectures, but it can't connect to Apex. (AFAIK)

Most of the other tools I found are doing the opposite of what I want - they let you design your scheme in a nice user interface and generate the according SQL statements afterwards.

As it was mentioned in the comments (and in other questions on stackexchange), it's possible to connect to Oracle Apex through ODBC, generating a diagram with some tools, i.e. Microsoft Visio.

Maybe I have to do it this way, but I was curious, if it's possible even without an existing database scheme; just SQL.

Is there a free (better: open source) tool which analyzes given CREATE TABLE-statements, including foreign keys, to an entity relationship diagram?

  • As in Oracle APEX? There are plenty of apps that will connect to an Oracle database and generate ERDs from schemas – Philᵀᴹ May 14 '14 at 16:43
  • @Phil yes, Oracle Apex - if there is no tool like the one I'm looking for, I guess I have to do it this way. – stuXnet May 14 '14 at 16:59
  • Maybe this previous question on stackexchange helps you: dba.stackexchange.com/questions/14172/… – Guido Leenders May 14 '14 at 21:41
  • 1
    I can imagine. We've written our own. We extract datamodel into graphml and then use yEd to lay it out nicely. – Guido Leenders May 15 '14 at 7:25
  • 1
    yes. your brain. a pencil, and (if you want to get really fancy) graph paper. – swasheck Oct 3 '14 at 15:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.