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.


Table Editor - Using Navigation bar



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


Object group

iconDB select a database

iconObjects_Table select a table for editing


General group

iconRefresh refresh the content of the active tab

iconCompile compile the table (if it is being modified)

iconGrantsOnObject define grants on the table

iconPrint print metadata of the table

iconShowSQLHelp view MySQL reference

iconOptions adjust Table Editor options

iconRestoreDefaultSize restore the default size and position of the editor window


Tools group

iconTools_TruncateTable truncate data of the table


Explorer group

iconDBExplorer 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

iconObjects_AddField add a new field

iconObjects_EditField edit selected field

iconObjects_DropField drop selected field(s)

run Optimize field types wizard



Indices group

iconObjects_AddIndex add a new index

iconObjects_EditIndex edit selected index

iconObjects_DropIndex drop selected index(-es)


Foreign keys group

iconObjects_AddFK add a new foreign key

iconObjects_EditFK edit selected foreign key

iconObjects_DropFK drop selected foreign key(s)


Triggers group

iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)


Data Management group

iconCommit commit transaction

iconRollback rollback transaction

iconTools_ExportData export data

iconTools_ExportAsSQLScript export as SQL script

iconTools_ImportData import data

iconTools_LoadData load data

iconTools_SaveDataToFileOnServer save data to file on server


DDL group

iconSaveToFile save DDL to file

iconTools_SQLEditor 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 RadioButton Toolbar (if you need the toolbar only) or RadioButton Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.