Database Studio consists of several views and editors, which you can show and hide. Views can be opened only once, editors can be opened multiple times.
For more information about views and editors, see the Eclipse documentation at http://www.eclipse.org.
Screen Area |
Name |
---|---|
1 |
Menu |
2 |
Explorer Outline |
3 |
Editor window, which can contain the following special editors:
|
4 |
The following views are possible: Actions, Console, Databases, Details, Event Log Viewer, Explain, Properties, Diagnosis Chart and many other To add views, choose |
Explorer
Depending on your settings, the following areas are displayed in the explorer:
Menu bar
Entry |
Description |
---|---|
|
Opens the login dialog |
|
Opens the SQL editor Dropdown menu:
|
|
Opens the administration editor Dropdown menu:
|
|
Navigation |
|
Collapses all nodes in the explorer tree |
|
Activates or deactivates highlighting mode When you open an editor or view in highlighting mode, the corresponding database object in the explorer tree is highlighted. |
My Repository
For more information, see My Repository.
Explorer tree
For more information, see Explorer Tree.
Outline View
The code that you enter in an editor (such as the SQL editor) is displayed graphically in this view.
Administration Editor
You can carry out administrative tasks in this editor. Information on the database is also displayed.
For more information, see Administration Editor.
Table Editor
The table editor lets you edit table definitions.
For more information, see Table Editor.
View Editor
The view editor lets you edit view table definitions.
For more information, see View Editor.
Sequence Editor
The sequence editor lets you edit the definitions of sequences (number generators).
For more information, see Sequence Editor.
SQL Editor
In the SQL editor, you can enter and execute SQL statements.
For more information, see SQL Editor.
Visual Query Editor
In the visual query editor, you can enter SQL statements graphically and edit them, as well as display foreign key dependencies between tables.
For more information, see Visual Query Editor.
Help View
Online help
Console View
Status and confirmation messages are displayed in the console.
Database View
In this view, the system display status information about the databases.
Details View
In this view, the system displays details of the explorer.
Event Log Viewer
In this view, the system displays the Database Studio log file.
For more information, see Event Log Viewer.
Explain View
The result of EXPLAIN statements for SQL statements is displayed in this view.
For more information, see
Properties
In this view, the system displays database properties.