To open the Database Explorer window
Click .
The tree diagram displays database objects in the form of a tree layout. The behavior of this module is very similar to Windows-based applications. To expand or collapse the associated list of sub-items, click each branch name. To display the details of a database object, click the object name and the corresponding information will be displayed in the right pane of the window.
The Object Information displays information about the selected database object. By clicking a tab located at the bottom of the right pane, related details about the database object are displayed.
To modify table or view data
Select the table or view you want to modify from the left pane of the Database Explorer window.
Select the Data tab from the bottom of the right pane
Use the button bar at the bottom of the pane to select an editing option.
Note: Not all Views are updateable; a general rule is that any UPDATE, DELETE, or INSERT statement on a join view can be modified if only one underlying base table exists.
To facilitate the construction of a SQL statement, copy the selected column names to the SQL Optimizer or SQL Formatter windows.
To copy column names
Select the table or view name displayed on the tree diagram in the left pane [Database Objects] of the Database Explorer window.
Make sure the Column tab is active and select the column names by clicking the left-hand mouse button with the Shift key for multiple selections.
Right-click and select Copy columns to SQL Optimizer to copy the column names to the SQL Optimizer window or select Copy columns to SQL Formatter to copy the column names to the SQL Formatter window.
A new line and a comma separate each column name after the copy.
Below is a list of functions available in the Database Explorer window.
Button or Menu |
Function |
Edit Menu
|
|
Edit Menu
|
|
Edit Menu
|
|
Right-click Menu |
|
Right-click Menu |
|
Data Tab |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center