Using Intellisense
Intellisense is configured in Options dialog on Editor page.
Intellisense and temporary tables in MS Sql Server and Sybase ASE. For intellisense to work with temporary they have to be created and then "referenced". Referenced means that you have to type something in Editor to cause the information about them loaded. For example if you created temporary table named #tmp then just type #tmp. and after that #tmp table will start to show up in Intellisense list window.
If you drop and recreate temporary table with different definition you have to refresh objects in Object View in order to reset Intellisense information for temporary tables.
Intellisense Options Description
Enable Intellisense | Enables or completely disables following options |
Include System Tables | Display System Tables in Intellisense list |
Include System Procedures | Display System Procedures in Intellisense list |
Include Schemas/Databases | Display objects from other Schemas (Oracle, DB2) or other Databases (Sybase, MS) |
Enable Auto Complete For: | Enables or disable following options |
Keywords | Displays and enables autocomplete for Keywords |
User Objects | Displays and enables autocomplete for User Objects |
System Objects | Displays and enables autocomplete for System objects |
Capitalize Keywords | Automatically capitalizes Keywords after you type space or separator character |
Capitalize Procedures/Functions | Automatically capitalizes Procedures/Functions |