Table Editor

Just like any SQL management tool, you create and edit database structures through dialogs that generate SQL DDL. While editors of other SQL management programs tend to hide the generated code, Data Tools keeps that SQL on display in textareas at the bottom of each editor dialog. This serves two purposes. First, it allows you to keep a close eye on generated code, so as not to submit statements you don't intend. Second, it gives you an opportunity to keep the DDL syntax in your mind — an educational refresher.

The most important — and we think the most unique — feature of Data Tool is its database "Scope." Once an SQL statement is generated, it can be re-generated for a selected set of databases that define the scope.

How to Add a Column

  1. Sign-in to a MySQL database instance.
  2. Double-click a table name in the object list on the left of the main window. (If 'Table' type, which is the default, is not already selected, click the third popup menu from the top and select 'Table'.)
  3. In the Table Editor, click 'Add' to add a new column. At this point, you should see the generated ALTER TABLE statement appear.

    4. Table Editor

  4. Click on the 'Scope' tab at the top of the dialog.

    5. Table Editor Scope

  5. Select additional databases (schemas). Notice that additional statements are generated for each database that you select.
  6. Click 'Go', but only if you really mean it. The SQL statements are replaced into the Console window textarea, the editor is closed, and the statements executed.

Back to Table of Contents.