Question Re: How can I delete a tenant DB by using SQL command? in Technology Q&A

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

SAPSupport — Tue, 14 Feb 2023 03:27:10 GMT

Need to delete a tenant DB.
Referred to https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/4437e76879564f84aaa4dc4ca6332fc9.html
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.

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

SAPSupport — Tue, 14 Feb 2023 03:27:14 GMT

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/56e194dcf2f34e80a22c56483b6fcf18.html

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

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