1.

What Is Schema In Sap Hana?

Answer»

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 contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS etc.

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

There are 3 types of schemas:

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 contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO,_SYS_STATISTICS etc.

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



Discussion

No Comment Found