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. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center