Purpose of Default Schema for a stored procedure

[Former Member]

Hi All,

What is the purpose of a default schema option when there is already a schema selected when creating a stored procedure in HANA.

Thanks,

Goutham

[former_member182302 · Accepted solution]

Hi Goutham,

While you write your code. If you don't mention any schema name, example:

You mention as SELECT * FROM TABLE1.  And you mentioned : Default Schema as SCHEMA1, then it will check for TABLE1 under SCHEMA1.

i.e it will fire SELECT * FROM SCHEMA1.TABLE1.

Regards,

Krishna Tangudu