Modify the Data

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

1. Highlight a table from the text in the Editor pane in the SQL Worksheet window.

2. Click .

3. 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.

Related Topic

SQL Worksheet Window

New Database Session

The SQL Worksheet uses a different database session to execute the SQL and Transact SQL from the one that was created when you initially logged on. It is important to understand how using a different session affects your work in other modules.

Temporary Tables

Temporary tables created in the SQL Worksheet are not available throughout the rest of the modules. For example, if you create #temp1 in the SQL Worksheet, you are not able to use that temporary table in SQL Optimizer. Also, if you create a temporary table in the User-Defined Temp Table window, you will not be able to use it in the SQL Worksheet.

Changes to the Data Dictionary

Each time you logon, information from the data dictionary is loaded into the memory of the local PC. If you make changes to the data dictionary in the SQL Worksheet, these changes are not reflected in the information that was initially stored on the local PC. For example, if you create a new table in the SQL Worksheet and then optimize a SQL statement that uses the new table, you will get a message saying that the table does not exist. This is because the data dictionary on the local PC was not updated.

To update the data dictionary

Select Database | Synchronize Data Dictionary.

Related Topic

SQL Worksheet Window

Command List

The Command List stores each command that is successfully executed in a drop-down field at the top of the SQL Worksheet window. The following functions are available from the right-click menu in the Command List.

Save Commands

Brings up the Save Commands window so you can select which commands you would like saved to a file.

Load Commands

Brings up the Open Commands window so you can select which commands to load in the Command List from a list that you saved previously.

Clear Commands

Brings up the Clear Commands window so you can select which commands you would like remove from the Command List.

Related Topic

SQL Worksheet Window

Bookmarks

Bookmarks can be set to quickly return to a place in your code. To set a bookmark, right-click, select Toggle Bookmark or select Set | Toggle Bookmark and then pick a bookmark number between 0 and 9. The bookmark number displays in a field in the gutter in place of the line number.

To move the cursor to a bookmark

1. Right-click and select Goto Bookmark.

2. Select your bookmark number.

To move to the next or previous bookmark

Select Set | Previous/Next Bookmark.

Related Topic

SQL Worksheet Window