These pages cover SQL Prompt 7, which is not the latest version. Help for other versions is also available.

Skip to end of metadata
Go to start of metadata

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
  • No labels