Different schema types in SAP HANA database

In SAP HANA database, there are 3 types of schema −

• User Defined Schema: These schemas are created by database users or administrators. All the schemas under Catalog tab except from System defined and SLT derived schemas are user defined schemas.

• System Defined Schema: These are generated as result of using HANA related functions. These are of following types −

  • _SYS_BI

  • _SYS_BIC

  • _SYS_REPO

  • _SYS_STATISTICS

  • _SYS_XS-ENGINE

• SLT Derived Schema: These schema are generated as part of SLT Data replication in HANA.

John SAP

Updated on: 12-Mar-2020

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started