Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

Breakthrough Means for Designing Tables

People who work with databases usually have to work with tables. Actually tables are the most significant part of any MySQL database. dbForge Studio for MySQL provides table designer for creating tables and modifying them.

All actions from one grid

In dbForge Studio for MySQL table designer, you can create and edit tables from the tool's grid. It allows adding new columns in one click and specifying major properties without opening any extra windows. By checking the corresponding checkboxes, you can easily set and remove primary keys. By clicking on the corresponding field, you can add comments or define collations.

Under the grid, the table DDL is displayed and all changes you make are immediately reflected in this part of the editor. In case the view with the script is not necessary, you can change the window layout and it will be hidden.

Heuristics

To simplify creating columns, the application provides the heuristics feature. When you enter frequently-used column names, such as ID, Name, Price, etc, or when these words are a part of the name, the application will automatically set the data type that corresponds to the name.

Preview of changes

If you are editing an existing table, you can see all changes you make in the application SQL editor. It's enough to perform the changes in the visual grid and press the Script changes button - and they will be displayed in new SQL document. If you want, you can copy them to clipboard directly from Table designer.