SQL Prompt supports refactoring SQL objects and code in several ways. provides code refactoring actions that can be applied from directly within an SSMS query window, to help eliminate patterns that can make SQL code code error prone, harder for others to read and understand, and hard to edit without making mistakes. A SQL Prompt action can be applied to any highlighted text in a SSMS query window and there are actions to, for example, qualify an object to its schema, expand wildcards, remove unnecessary angle-brackets in identifiers, add semicolons and much more.

It can also perform full database code refactoring processes that will help eradicate database design mistakes as early as possible in the development cycle, before they become very expensive to fix. For example, its Smart Rename refactoring will rename objects and detect any dependent objects affected by the change. It also provides a Table Split refactoring to help correct database design mistakes, with minimal pain.

See: SQL Refactoring