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.
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:
The following static analysis tests are included: