Checking list of system schema in SAP HANA

This can be checked using below SQL query and it will display all system schema in HANA system.

select distinct BASE_SCHEMA_NAME from "SYS"."OBJECT_DEPENDENCIES"
where BASE_SCHEMA_NAME like ‘_SYS%’;

SAP ABAP Expert

Published on 25-Apr-2018 19:42:03

• Related Questions & Answers
• Checking list of all available schema in SAP HANA
• Checking SAP HANA Schema owner name
• Checking schema creation in SAP HANA database
• Checking performance of SAP HANA system
• Checking version of SAP HANA system
• Checking all tables and schema in SAP HANA
• Checking authoring schema job details in SAP HANA
• Checking System limits in SAP HANA
• Checking tables in a schema in SAP HANA database
• Checking existing password policy of SAP HANA system
• Checking object dependency in SAP HANA system
• Checking a table inside a schema in SAP HANA database
• Common system schema in SAP HANA Studio under Provisioning
• Checking XS Engine service in SAP HANA system
• Checking topology of SAP HANA