> SAP HANA System Generated Schemas - sapbasis

sapbasis

Share the Knowledge

Friday, 5 January 2018

SAP HANA System Generated Schemas

A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects. 


There are 3 types of schemas.
    1. User Defined Schema
    2. System Defined Schema
    3. SLT Derived Schema

User Defined Schema:
These are created by user (DBA or System Administrator)

SLT Derived Schema:
When SLT is configured, it creates schema in HANA system. All the tables replicated into 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.

No comments:

Post a Comment