HANA Database Schemas and Database Tables

HANA Database Schemas and Database Tables

The below artifacts are major part of the SAP HANA Database.

Schemas

Tables

SQL views

Sequences

Procedures and Etc….

Schema:

The schema contains the logical group of Database objects and it is the mandatory database object in the HANA and all database objects below to schema. So below establish to develop any database artifacts we need to create schema.

Data base objects are like a

Tables

Views

Procedures

Sequences

…

  

Steps to create Schema:

Go to Project Explorer - > Right click -> New -> File and it brings the pop up

Provide the schema name with the extension of the “.hdbschema” and Click Finish Button. It creates new window in HANA management studio to provide the syntax to provide schema.

Issue the command schema_name = “WORKSHOPA_00”;

Save the File.

Right click on the schema name and issue the Commit and Activate it.