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.