Good software to generate SQL from ER diagram? [closed]

Question

I am creating a database and I need to create some tables.

I would like to know which software do you use or recommend (preferably free) to generate SQL code from ER diagram.

Answer 1

Not free, but effective: Microsoft Visio.

It has a nice template for ER diagrams complete with relationships, primary key information, etc. I believe that it can both generate the schema in the database as well as create the diagram by pointing it at a database.

Answer 2

We've used Case Studio 2 for years to model a fairly complex schema - it's pretty good. We use it to create scripts for MySQL, Oracle and SQL Server. It is now called Toad Data Modeller: https://www.quest.com/products/toad-data-modeler/ There's a freeware version (not sure how this differs from the paid-for licenced version though)