What's new in SQL Prompt 5?

This topic describes the following new features:

Note: 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:

SQL Prompt 5.0 Help Linked GIF File Template

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.

Keyboard shortcut: with the mouse insertion point on the name of the object you want to script out, press F12.

For more information, see: Scripting an object as ALTER.