Red Gate SQL Prompt

Intelligent code completion for SQL Server

Published By:

Red Gate Software Ltd

Please see below for licensing options, pricing and availability.
Shipping is free within mainland UK (next working day subject to availability).

Product Variants

Red Gate SQL Prompt Pro

Red Gate SQL Prompt Std

Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

SQL Prompt automates the retrieval of database object names, syntax and snippets as you write, intelligently offering only appropriate code choices. In addition to displaying the object creation-SQL script, SQL Prompt is highly customizable so you can make it perform exactly the way you want. Using SQL Prompt will improve your productivity and dramatically reduce your time at the keyboard. See the animation below displaying a typical scripting event and how much effort and time SQL Prompt can save you.

Features

Table/View/Column/Sproc name completion
JOIN/JOIN ON syntax completion
Object creation-SQL viewing pane
Cross-database queries
Distributed queries with linked SQL Server instances
Scripted-but-unsaved objects included in candidate list
Cursors, cursor variables and related statements
Auto-uppercasing of keywords and pop-up after keywords
Expand wildcard to column names list
Column selector screen, plus qualify object/column names option

System Req.

The suggested minimum requirements for the machines you install SQL Prompt on:

Windows XP, Windows Vista, Windows 7, Windows Server 2003 or Windows Server 2008
SQL Server Management Studio (2005 or 2008, including SSMS Express), Visual Studio (2005 or 2008), or Query Analyzer
Microsoft .NET Framework 2.0 or later
MDAC 2.8 or later
256 MB RAM
500 MB hard disk space available during installation

SQL Prompt supports connecting to the following versions of SQL Server: