SQL Prompt helps with several ‘small-scale’ SQL refactoring tasks, the scope of which is generally limited to a single batch of code, or code object, on which you are working locally. These tasks are performed right within the SSMS query window, and help you refactor code in various ways that are extremely useful when testing and troubleshooting stored procedures.

• Scripting an object as ALTER
• Selecting an object in the Object Explorer
• Finding invalid objects
• Finding unused variables and parameters
• Summarizing a script
• Renaming objects
• Renaming scripted objects