views:

51

answers:

2

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.

+2  A: 

Red-Gate Software has a tool called SQL Refactor which should do what you're looking for.

marc_s
A: 

+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.

AdaTheDev