cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How can I delete a tenant DB by using SQL command?

SAPSupport
Employee
Employee
0 Likes
5,178

Need to delete a tenant DB.
Referred to https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/4437e76879564f84aaa4dc4...
However, there is no HANA Cockpit.
Question: how can I delete a tenant DB by using SQL command in HANA Studio?


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.
View Entire Topic
SAPSupport
Employee
Employee

Follow below steps to delete a tenant DB. You may execute them (below commands) from SYSTEMDB as SYSTEM user.
1. stop the tenant DB.
ALTER SYSTEM STOP DATABASE <database_name>;

Reference: https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/56e194dcf2f34e80a22c564...

2. delete the tenant DB.
DROP DATABASE <database_name>;

Reference: https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/9a94cd11182345d6bf13d22...