Customizing rules
Published 30 May 2017
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.