On this page

    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:

    1. Open the reflections editor for the reflection’s anchor or supporting anchor. See “Locations of the Reflections Editor”.
    2. Open the Advanced view, if it is not already open.
    3. If the reflection is an aggregation reflection, click Aggregation Reflections.
    4. Click the minus symbol for the reflection that you want to delete.
    5. Click Save. The deletion takes effect immediately.

    To delete all raw and aggregation reflections on a table or view:

    1. Open the reflections editor for the reflection’s anchor or supporting anchor. See “Locations of the Reflections Editor”.
    2. Click Remove All Reflections.
    3. 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:

    ALTER 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.