Checking tables in a schema in SAP HANA database


You can check this detail using a SQL query in HANA. You have to pass schema name in Where condition. Try running below SQL query and this will show you list of all tables in a schema.

Select distinct BASE_OBJECT_NAME from "SYS"."OBJECT_DEPENDENCIES" where BASE_SCHEMA_NAME like 'AF_HANA';

AH_HANA- Schema name

Updated on: 13-Mar-2020

2K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements