on ‎2023 Feb 14 3:27 AM
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?
Request clarification before answering.
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>;
2. delete the tenant DB.
DROP DATABASE <database_name>;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.