SAP HANA: drop Tenant Database

SAP HANA: drop Tenant Database

Note:
The use of this statement requires the DATABASE ADMIN privilege.


Log on to the SYSTEMDB  tenant with the <sid>adm user
ardbhp201:/ # su - bhpadm

Connect to the HDBSQL
ardbhp201:/usr/sap/BHP/HDB40> hdbsql -i 40 -d SystemDB -u SYSTEM -p <password>

Stop the tenant database
hdbsql SYSTEMDB=> ALTER SYSTEM STOP DATABASE NM2

Drop the tenant database
hdbsql SYSTEMDB=> drop database NM2

Share this

Unknown