- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 07:40:03
- Related Questions & Answers
- Checking schema creation in SAP HANA database
- Checking all tables and schema in SAP HANA
- Checking a table inside a schema in SAP HANA database
- Checking SAP HANA Schema owner name
- Checking authoring schema job details in SAP HANA
- Checking list of system schema in SAP HANA
- Different schema types in SAP HANA database
- Unloading tables in SAP HANA database
- Checking list of all available schema in SAP HANA
- Changing Ownership of schema in SAP HANA Database
- Refreshing a schema after creating a table in SAP HANA database
- Authoring schema vs Physical schema in SAP HANA
- Using Schema mapping in SAP HANA
- Setting schema mapping in SAP HANA
- Error: "invalid schema name" even if schema is present in the database in SAP HANA
Advertisements