Tool for sql refactoring? [closed]

Closed. This que开发者_StackOverflow中文版stion does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 9 years ago.

Improve this question

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

I have a set of views where only the top two are used, and I'd like to refactor this into only two views, hence 10+ queries into two queries.

---

Try ApexSQL Refactor

ApexSQL Refactor is a FREE SSMS and VS add-in, for formatting SQL statements using nearly 200 formatting options and 11 code refactors. 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, add surrogate keys and more

Disclaimer: I work for ApexSQL as a Support Engineer

---

Red-Gate Software has a tool called SQL Refactor which should do what you're 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 well worth the money for its license!)

---

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

I've never used it, so don't exactly know what it does but thought it worth a mention.