Checking tables in a schema in SAP HANA database

SAP HANASAPSAP Basis

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

raja
Published on 25-Apr-2018 23:09:53
Advertisements