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



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