Member Assistance provides a list of available objects within the database as you type.
To invoke Member Assistance press Ctrl-Space. By default this shows a simplified list of keywords, data types, and system functions along with all servers, databases, tables, views, stored procedures, user defined functions, and users/schemas available to your query.
When the list is showing, as you type the highlighted item is selected based on a best match from the current query text. You can also use the up and down keys to change the selected item.
To insert the selected item into the query double-click the list item or press the enter key.
The member list can be changed to display a full list of keywords, data types, and system functions (see changing options and preferences for more details).
As an alternative to displaying the full, or simplified, list you can display a categorized list (see changing options and preferences for more details). In this mode when you invoke the list you see a list of object types, such as keywords, tables, views, etc.
By selecting the desired type a new list will be displayed with only the items of that type. To select the category you can double-click on it or type the first letter of the category. e.g. to select a Stored Procedure press Ctrl-Space to invoke the Member Assistance list, press S twice to select Stored Procedures, and then select the desired stored procedure.
Member Assistance also provides a list of table and view columns. To invoke the column list press Ctrl-Shift-Space. As you click on a column a tool tip is displayed detailing the tables/views that column is defined within and the datatype/nullability of the column.
N.B. Member Assistance does not provide context based information. When invoked the list is the same no matter where it is invoked within the query.
Complete Word
If there is only one value within the member list that matches the current text you can click the Complete Word command. This will complete the word without presenting the Member Assistance list.