Types Of Schema in SAP HANA Database

 

Types Of Schema in SAP HANA database.

There are three types of Schema available in SAP HANA database The database schema is a way to logically group objects such as tables, views, stored procedures etc. 

1. User Defined Schema
2. System Defined Schema
3. SLT Derived Schema

 User Defined Schema:
These are created by user (Database administrator or System Admin)

SLT Derived Schema:
When SLT is configured, it creates schema in HANA system. All the tables replicated into SAP HANA system are contained in this schema

System Defined Schema:
These schemas are delivered with the SAP HANA database and contains HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO, _SYS_STATISTICS etc...,