Menus and commands

SQL Navigator menus and toolbars can be floating or docked, so you can put them where you want them. They are completely customizable. Your settings are saved and recalled automatically.

Scroll down for details, or choose a topic:

Main menu bar

Menus

Menu synchronization

Toolbars

Task bar

Main menu bar

$image\Sqln0012.gif$

The available commands change according to the current object (the object selected in the main work area). Also, they are completely customizable—you can add and remove commands to menus and toolbars. The following are typical default menus.

Default settings for SQL Navigator menus

This menu	Has commands for
File	Operations on files and workspaces, plus the Exit command
	$image\Sqln0185.gif$
Edit	Common text- and code-editing actions
	$image\Sqln0151.gif$
Search	Finding text, code and database objects
	$image\Sqln0152.gif$
View	Controlling what is displayed in the main application area
	$image\Sqln0153.gif$
Session	Session-wide actions
	$image\Sqln0154.gif$
Object	Operating on database objects
	Object menu when a table is selected ê $image\Sqln0186.gif$ Object menu when a stored procedure is selected ê $image\Sqln0150.gif$
Debug	Code debugging
	$image\Sqln0125.gif$
Tools	Invoking and controlling integrated tools
	$image\Sqln0155.gif$
Team Coding	Version control and team coding functions
	$image\Sqln0077.gif$
Windows	Controlling the arrangement of open windows in the SQL Navigator application area
	$image\Sqln0187.gif$
Help	Access to user-assistance
	$image\Sqln0188.gif$

Menu synchronization

The commands that are available in all windows change as different types of objects and windows are selected or opened.

Database objects associated with an open window become "current" for the entire SQL Navigator development environment.

Whenever you open a database object (a table, procedure, function, index, and so on) in one of the following windows, SQL Navigator enables all the appropriate menu or toolbar commands for that object.

$image\Sqln0004.gif$ DB Navigator

$image\Sqln0004.gif$ Find Objects

$image\Sqln0004.gif$ Code Search

$image\Sqln0004.gif$ Workspace

$image\Sqln0004.gif$ Describe tool

$image\Sqln0004.gif$ Visual object editors

For example, when an object is open in an editing window, you can use the Locate in Schema command to jump to that object’s node in the DB Navigator tree, expanding all intermediate nodes and opening the object’s details.

Toolbars

All toolbars in the main application window are customizable.

$image\Sqln0004.gif$ To see a hint about the purpose of any toolbar button, pause the mouse pointer over it.

$image\Sqln0004.gif$ You can move toolbars to any location in the workspace, and dock them at the bottom, left and right sides of the work area. Toolbars can float on top of the current window.

$image\Sqln0004.gif$ You can show and hide toolbars to provide more work space. You can change the shape of toolbars by dragging their horizontal or vertical boundaries.

$image\Sqln0004.gif$ The most recent window and toolbar size and position will be automatically restored upon reopening.

The following toolbars are available (by default) in the main window. If they are not visible, you may need to reset your toolbars.

Toolbar	Purpose	View toolbar
Session	Duplicates the Session menu and contains the Current Session selection box	$image\btn_mini.gif$

Edit	Duplicates the Edit menu	$image\btn_mini.gif$

Functions	Duplicates some commands found under the View, File, and Tools menus, and contains the Current Workspace combo box	$image\btn_mini.gif$

Debug	Duplicates the Debug menu	$image\btn_mini.gif$

Object	Duplicates the Object menu and contains the Current Schema combo box	$image\btn_mini.gif$

Team Coding	Duplicates the Team Coding menu	$image\btn_mini.gif$

$image\btn_Customizing_menus_and_toolbars96.gif$

Task Bar

In the lower part of the application window is a task bar that helps you keep track of windows and dialogs. Click an item to bring it to the top level.

Choosing a task from the Task Bar

$image\Sqln0189.gif$