Is there a style check tool for T-SQL, just like FxCop to .net?

Question

I'm looking for a tool to enforce coding styles, validation check for T-SQL script. And it recommends best-practice when appliable.

In .net code domain, the tool for this purpose is FxCop. Is there a counterpart for T-SQL? It will be best it is free or open source tool.

Anyone can shed some light?

Answer 1

Power Tools is your best bet.

Also, here is a Microsoft tool for verifying best practices. The documentation specifies it checks T-SQL. It may or may not do what you want.

2000

2005

Answer 2

Hi,

You may wish to look at the RedGate suite of tools, particularly SQL Refactor and SQL Prompt.

This will layout your T-SQL code in a standard fashion and also provide you the ability to customise the standards that are used for your specific shop.

http://www.red-gate.com/products/SQL_Refactor/index.htm

Cheers, John

Answer 3

You may looka at SQL Enlight. The tool can analyze SQL code for defects, identify potential performance and design related issues in your SQL Server databases.