DBDesigner

DBDesigner is a practical and straightforward piece of software that integrates database design, modeling and maintenance into a clean, user-friendly and seamless environment. Since it comes with support for MySQL, SQLite, Oracle and MSSQL databases, the program provides you with a convenient way to keep control of all the attributes, columns, indexes and tables with ease.

In case you want to open a new XML document, you can make use of the ‘Open’ function from the File menu. However, there might be situations when you simply need to create and analyze a diagram directly from your MySQL database. By using the ‘Open from Database’ option, you are able to create a new connection and choose the tables you are interested in.

The main window of the program will display the proper diagram along with its tables, data types and relationships. If you double-click on a specific table, you will notice that a new window will appear from where you can easily manage all the available variables and their attributes. You are able to modify the table name, insert new indices, change the table type and the values for each attribute.

By accessing the right-click menu, you are able to edit the current object or the table data, align all the elements to right or left, as well as copy default Create, Drop or Insert scripts that were used for the selected table.

The right panel displays three categories, namely ‘Navigator & Info’, ‘Datatypes’ and ‘DB Model’ from where you can easily manage and organize all the used variable types, basic information such as name, width and height margins, as well as track all the columns and relations for each table. What’s more, the ‘DB Model’ category displays the primary key for each table.

If you want to start working with SQL queries and create new scripts, you can navigate to the Display menu and access the ‘Query Mode’. The bottom pane of the application will change accordingly, sectioned by two columns, one for manually writing the scripts and one for displaying the data.

Overall, DBDesigner is an effective utility that comes in handy for database administrators who need to preview a full-detailed diagram, while executing SQL scripts and viewing all the primary keys for each table.