Using SQL Prompt

SQL Prompt provides intelligent auto-completion for SQL Server Management Studio, SQL Server Management Studio Express, Query Analyzer, and Visual Studio^® 2005, enabling you to build accurate SQL scripts much more quickly.

SQL Prompt displays a candidate list as you type, when you press CTRL+SPACEBAR, or when you type a trigger word. The candidate list shows items based on the context of what you type. Candidates are grouped by object type for you to select and insert into your query editor.

With SQL Prompt, you can:

expand column lists in SELECT * and SELECT table.* statements by pressing TAB
select columns using a column picker
apply keyword formatting as you type
view schema information if you are unfamiliar with the definition of an object
qualify object names and column names
execute stored procedures
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
customize SQL Prompt by specifying options

Cross-database queries, and distributed queries with linked SQL Server instances are supported.

For information on what's new in this version, see http://www.red-gate.com/support/versions/index.htm

For some examples of how you can use SQL Prompt, see Worked Examples. To see how you use the candidate list, see Using the Candidate List.