Click here to return to the home page
Change Currency      
 
Search:
Home » Catalogue » Database » Tools & Utilities » Red Gate SQL Refactor

Red Gate SQL Refactor


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.

  • 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
Help
My Account
Corporate Info
Other Info
Secure Shopping
Copyright © Grey Matter Ltd. 1983 - 2008. Registered office: 2 Prigg Meadow, Ashburton, Devon, TQ13 7DF. Registered in England. Company no: 1671407. VAT no: GB 384904621.