Sql refactoring tool?

Question

Is there a refactoring tool for SQL (in particular, TSQL). Is there any tool that can do automatic SQL simplification?

I have a set of views in which only the top two are used, and I would like to reorganize this into only two types, therefore, 10+ requests for two requests.

Answer 1

Try ApexSQL Refactor

ApexSQL Refactor is a free SSMS and VS add-in for formatting SQL statements using almost 200 formatting options and 11 code repositories. It expands wildcards, qualifies object names, renames SQL database objects and parameters without breaking dependencies, encapsulates code as a stored procedure, scalar function, table function and view, adds surrogate keys and much more

Disclaimer: I work for ApexSQL as a support engineer

Answer 2

Red-Gate Software has a tool called SQL Refactor that should do what you are looking for.

Update as BlueRaja correctly states: SQL Refactor has been discontinued as a separate product, and its functionality is now integrated into SQL Prompt (which is a great tool in itself, and costs money for its license!)

Answer 3

+1 to marc_s, which I suspect is what you're after. Just to add, the only other tool that I know about automatically refactoring SQL is Toad for SQL Server from Quest Software. Feature list here .

I never used it, so I don’t know exactly what it does, but I thought it was worth mentioning.