Different schemas in SAP HANA
Schemas are used to categorize database content according to customer defined groupings that have a particular meaning for users. Schemas also help to define access rights to the database objects. Schemas can help identify which tables to use when defining information models. But a model can incorporate tables from multiple schemas, which are:
- System defined
- User defined
- SLT derived schemas
System defined schemas are delivered with the SAP HANA database and contain the HANA system's information. These are system schemas such as _SYS_BIC, _SYS_BI, _SYS_REPO, _SYS_STATISTICS, and so on.
Let's see more about these system defined schemas:
_SYS_BIC: This schema contains all the column views of activated objects. When the user ...
Get Real Time Analytics with SAP HANA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
