What's new in SQL Prompt 5
Published 11 February 2013
This page describes the following new features:
Much of the functionality of the retired SQL Refactor is now available in SQL Prompt; for details, see: SQL Prompt and SQL Refactor.
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.
To try it out: in the SQL Server Management Studio Object Explorer, right-click the database you want to find invalid objects in, then click Find Invalid Objects:
For more information, see: Finding invalid objects.
Script Object as ALTER
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.
To try it out: right-click an object in a query, and click Script Object as ALTER.
For more information, see: Scripting an object as ALTER.
SQL Prompt 5 enables you to view a list of objects that reference a column.
To try it out: move the mouse pointer over a column in your query, and click the tooltip.
For more information, see: Viewing column dependencies.