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.
Types of Schemas :
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.
Types of Schemas :
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