How to Delete Table or Table Entries in HANA Studio

In this article, we are going to show you on how do we perform the table deletion or table entries removal by using HANA Studio.

1. First of all, launch and login to your SAP HANA Administration Console (Studio). Ensure you have logged into the correct database (SystemDB or TenantDB).
2. Drill down the category from Database (TenantDB or SystemDB) > Catalog > Tables. Look for your table and right click to select Delete.

3. Now, from below dialog box, there are 2 options to choose.

• Delete Catalog Object
  • If you choose this option, it will delete the table completely. You can find the table anymore from database. Before you execute, please consider below remarks,
    • Restrict (If dependent objects exist, no objects will be deleted)
    • Cascade (Caution: The object and all its dependent objects will be deleted.

• Delete All Rows
  • If you choose this option, it will delete all your entries from the table. The table will still be exist without no data.