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.