In HANA database environment, you can have multiple schema created in your database setup. There are 3 ways to find out all the available schema inside your HANA database.
Method 1
For the first method, you can use the SAP HANA Studio. Once you launch and logged into the tenant database. Click on Catalog and from here, you will see the list of available schema from the drop down list.
Method 2
For method 2, we will still be using the SAP HANA Studio. Now, open the SQL console from the tenant database and execute below command,
select * from schemas
The command will list all the available schemas from your tenant database.
Method 3
This time, we will be using SAP GUI. Open transaction code DB02 and double click on Table/Views.
Put your cursor on the Schema field and press F4. You will get all the available schemas from the entries.
