Customizing rules

The full list of exceptions is:

  • BP017 – AllowedTables
  • BP018 – AllowedTables
  • ST011 – AllowedTables
  • ST012 – AllowedTables for BP017 DELETE statement without WHERE clause
  • BP018 – UPDATE statement without WHERE clause
  • ST011 – Consider using table variable instead of temporary table
  • ST012 – Consider using temporary table instead of table variable

These names should be provided in the form of a regular expression supported by the Regexp class. So if you want to exclude a table where the name starts with ‘z’, you should write ^z.*, for example. For further hints on the Regular Expression language, read this Quick Reference.


Didn't find what you were looking for?