Display Schema List on SAP HANA Database
SAP users can get the list of all schemas created on SAP HANA database with the schema owner name by executing SQL query on SYS.Schemas view.
Here is the SQLScript SELECT statement for database developers to display and return the list of all schemas on the HANA database.
select
schema_name,
schema_owner
from sys.schemas;
-- or using the public synonym
select * from schemas;
