Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Prithwi Thakuria: "I have been in the database field for eons. This is one the best suite of tools I have found in terms of cost, functionality and performance. Ever since we bought this array of products, life with databases have been a breeze and the productivity has soared immensely. Keep up the good work".
Torstein Krogh: "Some time ago, I tested all available tools on the market for maintaining MySQL and MySQL Maestro came up on top. My opinion is that MySQL should offer it as a free tool for all paying customers! They have nothing today, and doing MySQL DOS commands is not getting any new customers".

More

Add your opinion

SQL Maestro for MySQL product tour

Features of SQL Maestro for MySQL:

Working with Tables

SQL Maestro for MySQL provides wide opportunities to create and edit objects. Each object is created and edited within the appropriate wizard and handy editor. Let's consider the process of a new object creating by the example of Create Table Wizard.

Easily understandable wizard steps allow you to specify all table properties and also all table subobjects (fields, indexes, triggers and foreign keys for InnoDB tables) properties.

Database Object Editors are the basic SQL Maestro for MySQL tools for working with existing objects. The proper editor can be opened automatically after the object is created and is used for specifying and editing necessary object properties. You can also open the necessary object editor within the Explorer Tree or Object Manager.

In the similar manner, let's consider the object editing by the example of Table Editor:

The Navigation bar of the editor provides possibilities to analyze, check, repair and optimize the current table.

The editor consists of a several tabs: Properties, Subitems, Data, Permissions, SQL. Every tab allows you to set corresponding table characteristics.

So, to edit main table properties such as name, comment, engine and others use the Properties tab.

The Subitems tab of the Table Editor is very helpful to manage table subobjects: fields, indexes, foreign keys, triggers, foreign key references. Just choose the appropriate part and edit the grid.

The main parts of each Object Editor are the Data and Permissions tabs. 

To practice table data management, select the Data tab. For your convenience it was supplied with two view modes:  as a table and as info cards.

The Permissions tab is provided to control users' permissions on the table. The SQL definition of the table is also available.

Back Next