Online Documentation for SQL Manager for DB2

Using Navigation bar and Toolbar


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

 

New table - Using Navigation bar

 

 

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

Database group

iconDB select a database to create a new table in

 

General group

iconCompile compile the newly created table

iconRestoreDefaultSize restore the default size and position of the editor window

 

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)

 

Dimensions group

iconObjects_AddDimension add a new dimension

iconObjects_EditDimension edit selected dimension

iconObjects_DropDimension drop selected dimension

 

Partitions group

iconObjects_AddPartition add a new partition

iconObjects_EditPartition edit selected partition

iconObjects_DropPartition drop selected partition

 

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.