Using SQL Prompt

SQL Prompt provides intelligent auto-completion for SQL Server Management Studio or Query Analyzer enabling you to build accurate SQL scripts much more quickly.

SQL Prompt displays a candidate list as you type or when you press CTRL+SPACEBAR. The candidate list groups items by object type for you to select and insert items in your query editor.

With SQL Prompt, you can:

select columns from tables using a column picker
expand column lists in SELECT * and SELECT table.* statements by pressing TAB
apply keyword formatting as you type
view schema information if you are unfamiliar with the definition of an object
insert default snippets of code for commands you use infrequently, such as Data Definition Language (DDL)
create snippets of code for queries you run regularly
assign aliases automatically, including custom aliases

For an overview of how you use SQL Prompt, see Worked Examples. To see how you use the candidate list, see Using the Candidate List.