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 activates any of the views, say the attribute view/analytical view / the calculation view, the respective runtime objects are created under the _SYS_BIC column view.
• _SYS_REPO: This contains a list of activated objects, inactive objects...