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.