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.

John SAP

Published on 21-Feb-2018 19:12:13

• Related Questions & Answers
• Changing Ownership of schema in SAP HANA Database
• Changing authoring schema of catalog objects in SAP HANA
• Using Package specific default schema in SAP HANA
• Authoring schema vs Physical schema in SAP HANA
• Using Schema mapping in SAP HANA
• Setting schema mapping in SAP HANA
• Taking schema wise backup in SAP HANA
• Taking backup of schema in SAP HANA
• Use of _SYS_BIC schema in SAP HANA
• Use of _SYS_BI schema in SAP HANA
• Different schema types in SAP HANA database
• Checking schema creation in SAP HANA database
• Checking SAP HANA Schema owner name
• Checking all tables and schema in SAP HANA
• Checking authoring schema job details in SAP HANA