Is there a tool for refactoring SQL, a bit like a ReSharper for SQL

user_83083 0
Viewed 11180

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

refactoring sql-server sql
7 Answers
user_591110

I have used Embarcadero Rapid SQL for code formating.

user_1090350
user_2096680

SQL Prompt has basic format and beautify functions now, if you don't want to buy both products

The free SSMS Tools Pack supports basic beautify as well I believe http://www.ssmstoolspack.com/Features?f=3

Uppercase/Lowercase keywords and proper case Database Object Names. Set all keywords to uppercase or lowercase letters. Custom keywords can be added. Format all database objects to their proper case sensitive name.

jerryhung_375680
Related