Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Edit SQL > Complete SQL Statements Automatically

Complete SQL Statements Automatically

Use code completion to select from a list of tables, columns, views, or other objects without having to manually enter the object's name in the Editor. For example, you can enter the first few characters of the column name and then press ENTER to automatically complete the column name.

To access the code completion list

In an Editor window, do one of the following:

Press PERIOD at the location where you want to display a list of objects.

Press CTRL+PERIOD to manually open the code completion list.

Note: If a comment is available for an item in the code completion list, the comment displays in a tooltip when you select the item from the list.

Tip: Specify code completion options in Tools | Options | Editor | Code Completion. You can specify case, use of quotes, delay time, and what objects to include in lists.