Different schema types in SAP HANA database

SAP HANASAPSAP Basis

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.

raja
Published on 23-Apr-2018 14:56:44
Advertisements