Toad Data Modeler

Toad Data Modeler is an application that not only allows you to design database schemes, it also generates the necessary SQL code to reproduce them.

With it, you can create diagrams for the most common database management systems: Access, Firebird, InterBase, MySQL, Oracle, Paradox, Postgre, Sybase and many more.

The application is very useful in creating entity-relationship or detailed HTML and RTF reports, defining referential integrity, or generating SQL scripts to create the database.

Furthermore, it has a tool called 'Model Explorer' that allows you to navigate through all the features of the model you're creating.