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 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.
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
