
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