To remove extended storage in SAP HANA Studio, simply execute the following in a SQL console:
DROP EXTENDED STORAGE CASCADE
Once you have executed the above statement, under the Systems view, refresh “<SID>
(TPCH)”. Then click on the drop down arrows in the following order: <SID>
(TPCH) > Catalog > TPCH > Tables. You should notice how there no longer exist any extended storage tables.
Note: The term “CASCADE
” means that any dependent object on the extended storage will also be deleted. Therefore, if you have any extended tables, they will be deleted along with their data.
Ignore this line. it is used for formatting.
To remove extended storage in SAP HANA Cockpit, Navigate again to “Configure Dynamic Tiering”.
You should see the following and locate the “Delete” button in the bottom right of the window.
Once you click on “Delete”, you should see the following show up. The “Restrict” option checks if there are any objects relying on the extended storage. If there are any, the delete will not occur. On the other hand, the “Cascade” option will delete all dependencies of the extended storage(the extended tables).