Online Documentation for SQL Manager for MySQL

Using Navigation bar and Toolbar

The Navigation bar and Toolbar provide quick access to tools implemented in Table Editor.

 

 

 

The Navigation bar of Table Editor (in the Edit table mode) allows you to:

 

Object group

select a database

select a table for editing

 

General group

refresh the content of the active tab

compile the table (if it is being modified)

define grants on the table

print metadata of the table

view MySQL reference

adjust Table Editor options

restore the default size and position of the editor window

 

Tools group

truncate data of the table

 

Explorer group

browse the table subobjects using the Explorer tree

 

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with the table:

 

Columns group

add a new column

edit selected column

drop selected column(s)

run Optimize column types wizard

 

 

Indices group

add a new index

edit selected index

drop selected index(-es)

 

Foreign keys group

add a new foreign key

edit selected foreign key

drop selected foreign key(s)

 

Triggers group

add a new trigger

edit selected trigger

drop selected trigger(s)

 

Data Management group

commit transaction

rollback transaction

export data

export as SQL script

import data

load data

save data to file on server

 

DDL group

save DDL to file

open DDL in SQL Editor

 

 

Items of the Navigation bar are also available on the ToolBar of Table Editor. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select Toolbar (if you need the toolbar only) or Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.