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;