The Intellisense List The intellisense list is context aware, meaning that it knows where you are inside your query or script.  It will only display items in the list that are relevant to the current context.  As you type, the list will filter down to items that contain what you have typed, making it easy to find the item that you are interested in after typing only the first two or three characters.  You can even type in acronyms and the list will retain items that contain those characters in that order (ex. Type “QPU” and the list will retain “QuantityPerUnit”).  Below are a list of the most common contexts that SqlAssist is aware of.
Tables, Views, Aliases, Temp Tables Behind SELECT, JOIN, and WHERE statements (and many others), the list will contain all database tables and views, and also the local script aliases and temp tables.  The different types may be distinguished by their icons.
Columns After the dot (.) is typed behind a table or view, a list of columns for that table or view are displayed.
Note that this even works for all aliases and most temp tables.
Foreign Keys for JOINs One of the more impressive features is the automatic handling of JOIN statements.  Once a user types the ON keyword (followed by space or tab), a list of foreign keys will show.  The will list contain foreign keys where tables reference the table being JOINed, and foreign keys where the table being JOINed references other tables.  If one of the items is selected and entered, SqlAssist will enter the entire JOIN restriction clause for that foreign key.  If tables have been aliased, the aliases will be substituted for the table names.  The algorithm can even handle foreign keys that join on multiple columns at a time.
Local Variables SqlAssist parses your script for local variables, and makes those available in the list.  Simply type the “@” character and the list will pop up containing both standard keyword variables and variables that you have defined in your script.  Stored procedure and function variables will also be available soon.
Parameter Information SqlAssist shows parameter information for stored procedures and functions (system and user).  Parameter names and data types are both displayed.