In Server Studio, you use one window to perform most development functions: object creation, editing, navigating, and browsing. This window contains several panes and tabbed pages for performing these development functions.
The Server Studio window contains a Main menu, Main toolbar, Explorer pane, Document pane, and Document status bar.
Main Menu
You will find the Main menu at the top of the Server Studio window. Some menu items are dynamically added by the active document in the Document pane. For example, the SQL Editor adds the SQL menu item and the Table Editor adds the Table menu item.
For an explanation of each menu, see Menus.
Main Toolbar
You will find the Main toolbar at the top of Server Studio under the menu bar. It is composed of smaller toolbars grouped by functionality: File, Editing, Search, and Help. In addition, an active document in the Document pane adds its own toolbar after Search. For example, the SQL Editor inserts Execute, Execute Selected and Cancel Query buttons, while Table Editor inserts Add, Remove and Properties buttons.
Explorer Pane
The Explorer pane hosts explorer components such as the Object Explorer or the DB Difference Analyzer.
Server Studio JE Standard edition
contains only one explorer, the Object Explorer. The add-on modules dynamically
add other explorer components. For an explanation of add-on modules, see
Add-On
Modules . If more than one
explorer exist in the Explorer pane, multiple tabs are created at the
bottom of the Explorer pane. Each tab displays the name of the explorer
component inside that page.Document Pane
The Document pane displays all open Server Studio documents as
a set of tabs. Server Studio documents are SQL Editor, Table Editor, Properties
Inspector and documents such as Permission Editor or DB Diff Results that
can be created with add-on modules. Documents can be opened in the Document
pane using the Main menu or toolbar or as a result of navigation from Object
Explorer or other explorers.
You can open documents concurrently.
Each document maintains its own content and logical database connection. The
name and type of each document appears on a tab at the top of
the document in the Document pane. When you click on a tab, the
document inside the tab becomes the current document and its menus and toolbar
shows up at the Main menu and toolbar.
The Document pane has a popup menu to close a document and save its content. To display the popup menu, right-click on the current document tab. The Save and Save As operations are document specific and are enabled only if the document supports these operations.
Document Status Bar
The Document status bar is displayed at the bottom of the Document pane and displays status messages produced by the current document in the pane. Server Studio can perform asynchronous processing. This means, for example, that you can execute long query from one SQL Editor document and type text in another one while the first query is being executed. The status bar displays the state of the current document.