Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
An enumeration of possible values for a refresh type.
public enum RefreshType
type RefreshType =
Public Enum RefreshType
Append data to this partition and recalculate all dependents. This command is valid only for regular partitions and not for calculation partitions.
If the object needs to be refreshed and recalculated, refresh and recalculate the object and all its dependents. Applies if the partition is in a state other than Ready.
Recalculate this object and all its dependents, but only if needed. This value does not force recalculation, except for volatile formulas.
Clear values in this object and all its dependents.
Refresh data in this object and clear all dependents.
Defragment the data in the specified table. As data is added to or removed from a table, the dictionaries of each column can become polluted with values that no longer exist in the actual column values. The defragment option will clean up the values in the dictionaries that are no longer used.
For all partitions in the specified partition, table, or database, refresh data and recalculate all dependents. For a calculation partition, recalculate the partition and all its dependents.