Features:

• Smart Rename renames functions, views, stored procedures and tables, and updates all the references to these renamed objects. You can select this feature from the context menu in Management Studio's Object Explorer
• Smart Rename parameters and columns renames parameters of stored procedures and functions, and columns of tables and views. You can select this feature from the context menu in Management Studio's Object Explorer
• Encapsulate As New Stored Procedure turns your selection into a new stored procedure and, if requested, introduces a reference to it in your script
• Qualify Object Names modifies the script so that all object names are qualified. You can select this feature from the top-level SQL Refactor menu
• Expand Wildcards expands SELECT * statements to include a full list of columns in the select part
• Find Unused Variables and Parameters shows you the variables and parameters in your script that are not used, or that are only assigned to
• Summarize Script provides you with an overview of your script. By highlighting items in this overview, you can see the corresponding statements highlighted in your script
• Split Table splits a table into two tables, and automatically rewrites the referencing stored procedures, views, and so on. You can also use this refactoring to introduce referential integrity tables. You can select this feature from the context menu in Management Studio's Object Explorer
• Lay Out SQL reformats your T-SQL scripts. There are over 30 options to control this feature. Lay Out SQL, and these options, can be accessed from the top-level SQL Refactor menu
• Uppercase Keywords turns keywords in your script or selection to uppercase