Drops persistent cache and recreates it. Can be used only with views that have a persistent cache configured. Secondary cache option is available only for a persistent cache with rotated tables. Internally uses qua_create_view_copy.
qua_trim_view_copy 'view_name', 'copy' [;]
Fully qualified name of view which data will be affected.
SYSNAME that can be one of two values: ‘primary’ or ‘secondary’.
Drops and recreates primary cache copy for AdventureWorksDW2012_spark.dbo.DimEmployee.
EXEC qua_trim_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'primary';