This tutorial will explain how to create the SCHEMA in the HANA database.

1) Open SAP HANA Studio


2) Login to the SAP HANA system with credentials

11-26-2015 5-05-42 PM

3) Click on the SQL editor button. On the right side the SQL console will be opened.

11-26-2015 5-20-20 PM

4) Type the following command ( CREATE SCHEMA { SCHEMA NAME};) and Click the Execute button or hit F8 key.

11-26-2015 5-22-21 PM

5) Right Click the Catalog and refresh it.

11-26-2015 5-22-50 PM

6) The created Schema will be listed in the Catalog. Navigate the to the folders.

11-26-2015 5-23-07 PM

7) If you check the tables folder no tables are listed.

11-26-2015 5-23-20 PM

Next tutorial I will teach how to load the table into Schema by different provisioning methods.

Post a Comment

  1. Ahaa, its nice conversation regarding this piece of writing here on this weblog, I have read all that, so now me also commenting here. This post: How To Lock Files In 15 Minutes And Still Look Your Best