Syntax error Checking list of system schema in SAP HANA

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

981 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements