Sunday 24 September 2017

Types Schema in SAP HANA database

Tags


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

Types of Schemas :

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

User Defined Schema:  

These are created by user (HANA DBA or System Administrator

SLT Derived Schema:  

When SLT is configured, it creates the schema in SAP HANA system. All the tables replicated into SAP HANA system are contained in this schema 
System Defined Schema:
These schemes are delivered with the SAP HANA database and contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO, _SYS_STATISTICS etc. 




EmoticonEmoticon

Note: only a member of this blog may post a comment.