How to Find HANA DB List for Multi Tenant Databases

You wanted to know the list of HANA databases list from a multi tenant database.

Solution

The following steps is based on SAP HANA Studio.

So, firstly, you need to ensure that your ID is assigned with DATABASE ADMIN or DATABASE STOP or DATABASE START privilege in the SYSTEMDB before you can perform the activity.

Launch the SAP HANA Studio, login to SYSTEMDB and open the SQL console.

Run the following query,

select * from M_DATABASES

Reference

  • SAP Note 2690622 – How to list all the HANA databases for Multi tenant Databases

You May Also Like

Leave a Reply?