SQL Prompt 5

What's new in SQL Prompt 5

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.

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.

Column Dependencies

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.

Didn't find what you were looking for?