Is there a tool for refactoring SQL, a bit like a ReSharper for SQL
refactoring, sql, sql-server
Solution
JetBrains have just announced 0xDBE - a new IDE for SQL machines.
It's build on the IntelliJ platform, so should have many of the same shortcuts you get in the JetBrains suite of products.
http://www.jetbrains.com/dbe/
Problem
The sort of stuff I'm after right now is quite basic: - Auto format - Detect unused variables - Variable naming convention checking I wouldn't be surprised if there was a tool available that could handle more complex refactorings such as those found in Refactoring Databases, but I appreciate that the added complexities introduced by current db structure and data state may prevent many of them. I suppose I'm after ReSQLer