SQL Prompt finds invalid objects

Version 5.0 enables you to view column dependencies, and adds SQL Refactor functionality.

Zoom [+]

Defining layout options for data statements.

SQL Prompt automates the retrieval of database object names, syntax, and snippets as you write, intelligently offering only appropriate code choices. Automatic script layout provides easy code readability – particularly useful when working with unfamiliar scripts. SQL Prompt is highly productive straight out of the box. It is also customizable so you can make it perform exactly the way you want it to. Using SQL Prompt will improve your productivity and dramatically reduce your time at the keyboard.

The following editions are available:

• SQL Prompt Pro
• SQL Prompt Standard

SQL Prompt is also available as part of the following bundle offerings from Red Gate Software:

• SQL Developer Bundle
• SQL Toolbelt
• SQL Prompt Bundle

Updates in V5.0

• Find Invalid Objects
  SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.
• Script Object as ALTER from a query window
  If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.
• View column dependencies
  SQL Prompt 5 enables you to view a list of objects that reference a column.
• SQL Refactor functionality
  SQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Professional Edition, including Smart Rename, Qualify Object Names, Expand Wildcards, Split Table, Encapsulate as New Stored Procedure, Find Unused Variables and Parameters, and Summarize Script.

About Red Gate Software

Red Gate Software counts Microsoft, HP, Sage, Bank of America, AT&T, the US Treasury and over 9,000 other leading organizations as customers of its software development tools. There are over 100,000 Microsoft technology DBAs, developers and testers currently using Red Gate products. The company believes that by producing simple tools that solve the technical problems of Microsoft technology professionals it will continue to add value to the software development community. Therefore, it does not sell 'integrated' software with large, often unnecessary, feature sets. Red Gate was founded in 1999 and moved to Cambridge at the start of the year 2000. It is a privately owned and managed company. Its focus is on Microsoft technologies. Red Gate was chosen as a Global Gold Launch Partner for Microsoft Visual Studio .NET and are a Visual Studio Integration Program partner.