SQL Test includes a number of static analysis tests you can run to detect issues with your database. For a comprehensive set of over 100 advanced static code analysis rules for SQL, Redgate offers SQL Code Guard.

SQL Cop tests were contributed by George Mastros of Less Than Dot.

Adding the SQL Cop tests

To add the tests, when you add a new database to SQL Test, make sure the Add SQL Cop static analysis tests check box is selected:

To add the tests to a database you've already added to SQL Test, in the SQL Test tab right-click the database and click Add SQL Cop Static Analysis Tests:

List of tests

The following static analysis tests are included:

To download the tests, click here.