Modify Data
In the SQL Worksheet, you can modify the data from a table. The Edit button is not enabled until text is highlighted in the Editor pane.
To modify the data in a table
-
Highlight a table from the text in the Editor pane in the SQL Worksheet window.
-
Click
.
-
Use the Edit button bar at the bottom of the pane to modify the data.
Note: If you create a table and enter data in the SQL Worksheet, you must synchronize the data dictionary by selecting Database | Synchronize Data Dictionary before you can use the Edit command or Edit button to modify the data.