Changing default schema in SQL console in SAP HANA


To change the default schema, you have to select schema name from Catalog folder and click on SQL tab at the top.

You can also right click on Schema in which you want to create Relational objects and select Open SQL Console. In below pic, you can see the Schema AA_HANA11 and right click → Open SQL Console.

At the top of SQL console, you can see Schema name where the objects will be created using this console.

Updated on: 21-Feb-2020

1K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements