Home » Catalogue » Database » Tools & Utilities » Red Gate SQL Refactor

SQL Refactor [5 Users, 24 Months Support and Maintenance]

	Reference Number: PRS. 240376 Availability: Usually delivered within 2 working days Media: Electronic £870.21 (Ex. VAT)	Published By: Red Gate Software Ltd » Call me about this product » All variants of this product » Other products by this publisher » Similar Products
	Not what you're looking for? Use our free sourcing request service.
SQL Refactor allows you to automatically format your SQL code and database objects in the style of your choice. SQL Refactor improves the quality of your code, making it easier to read, understand and share amongst a team. A companion tool to SQL Prompt, SQL Refactor dramatically speeds up database development and administration, without impacting on the behavior of your database and applications.

Features
System Req.

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.
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.
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.
Uppercase Keywords turns keywords in your script or selection to uppercase.
Summarise 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.
Encapsulate As New Stored Procedure turns your selection into a new stored procedure and, if requested, introduces a reference to it in your script.
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.
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.

Windows 2000, Windows XP or Windows 2003 Server
SQL Server client-side tools
SQL Server Management Studio
Microsoft .NET Framework 2.0
MDAC 2.8+
128 MB RAM
10 MB hard disk space
Runs on a user's PC (can also run on a server)

Home » Catalogue » Database » Tools & Utilities » Red Gate SQL Refactor