Deleting Reflections
You can delete Reflections individually, or all of the Reflections on a table or view. When you delete a reflection, its definition, data, and metadata are all deleted.
To delete a single raw or aggregation Reflection:
- Open the Reflections editor for the Reflection's anchor or supporting anchor. See "Locations of the Reflections Editor".
- Open the Advanced view, if it is not already open.
- If the Reflection is an aggregation reflection, click Aggregation Reflections.
- Click the minus symbol for the Reflection that you want to delete.
- Click Save. The deletion takes effect immediately.
To delete all raw and aggregation Reflections on a table or view:
- Open the Reflections editor for the Reflection's anchor or supporting anchor. See "Locations of the Reflections Editor".
- Click Remove All Reflections.
- Click Save. The deletion takes effect immediately.
To delete an external reflection, or to delete a raw or aggregation Reflection without using the Reflections editor, run this SQL command:
Delete a ReflectionALTER DATASET <DATASET_PATH> DROP Reflection <REFLECTION_NAME>
- DATASET_PATH: The path of the view on which the external Reflection is based.
- REFLECTION_NAME: The name of the external Reflection.