RefreshType Enum
Definition
Important
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 RefreshTypetype RefreshType = Public Enum RefreshType- Inheritance
-
RefreshType
Fields
| Name | Value | Description |
|---|---|---|
| Full | 1 | 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. |
| ClearValues | 2 | Clear values in this object and all its dependents. |
| Calculate | 3 | Recalculate this object and all its dependents, but only if needed. This value does not force recalculation, except for volatile formulas. |
| DataOnly | 4 | Refresh data in this object and clear all dependents. |
| Automatic | 5 | 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. |
| Add | 7 | Append data to this partition and recalculate all dependents. This command is valid only for regular partitions and not for calculation partitions. |
| Defragment | 8 | 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. |