The ManagerSchema_PurgeDataFiltering.sql script removes all data filtering data from the Unica Platform system tables without removing the data filter tables themselves. This script removes all data filters, data filter configurations, audiences, and data filter assignments from Unica Platform.

When to use ManagerSchema_PurgeDataFiltering.sql

You might want to use ManagerSchema_PurgeDataFiltering.sql if you need to remove all data filters without removing other data in the Unica Platform system tables.

Important: The ManagerSchema_PurgeDataFiltering.sql script does not reset the values of the two data filter properties, Default table name and Default audience name. If these values are no longer valid for the data filters you want to use, you must set the values manually on the Configuration page.