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%’;

Updated on: 2020-03-13T07:40:40+05:30

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements