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.
User Defined Schema:
SLT Derived Schema:
System Defined Schema:
There are 3 types of schemas.
- User Defined Schema
- System Defined Schema
- 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