SQL Editor provides suggestion capabilities for both DML statements and objects. It has the ability to look up object names in order to avoid errors when defining table names, columns, etc. in the development process. This feature provides lists of object and code suggestions that will make the development process more efficient as you will not be forced to manually look up object names and other statement values. SQL Editor provides code assist for SELECT, UPDATE, INSERT, and DELETE statements (as well as for MERGE statements on SQL Server 2008 and higher) and object suggestion support for tables, alias tables, columns, alias columns, schemas, and catalogs.

To activate code assist

  1. Click the line on which you want to activate the code assist feature.
  2. Press CTRL + Spacebar on your keyboard. Code assist analyzes the line and presents a list of suggestions as appropriate based on the elements of the statement.