Object Filter

Select the objects that you want to include in the analysis and remove the unwanted.

Object Types

To include an object type in the analysis, select the object type check box. Objects from unselected object types will not be included in the analysis. However, there are cases when you want to analyze only a subset of all available database objects. A possible scenario may be that you have a SQL Server database with a large number of objects and want to analyze only those objects that have been added or modified in the database during the last change management cycle. Limiting the number of object types to be analyzed can significantly save processing time and resources.

Use Filter

You can apply your own custom filters to each selected object type. To create such a custom filter, select the "Use Filter" check box for that object type. When "Use Filter" is selected, ApexSQL Clean adds a corresponding object type to the Object Filter node in the Project Wizards tree where you can create your custom filter criteria. This filter supports wildcard searches on object names and you can limit the scope of your object selection for analysis.

Note that an already created filter is removed and needs to be recreated when you clear the Select check box.

Bitwise Set

The Bitwise Set value is automatically calculated by ApexSQL Clean and represents the bitwise integer value for the currently selected of object types. You can use this number as argument for CLI switches to include/exclude specific object types.