December 15th, 2010

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 Pro Edition:

• Smart Rename
• Qualify Object Names
• Expand Wildcards
• Split Table
• Encapsulate as New Stored Procedure
• Find Unused Variables and Parameters
• Summarize Script