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:
Fields group
add a new field
edit selected field
drop selected field(s)
run Optimize field 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
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.