SAP HANA XSA: SQL Current Space

[draschke]

Hi experts,

is there a way to get the current space by SQL?

And one more, is it possible that the system creates in two different spaces a container with the same HDI-ContainerID?

Thanks for your help!

Regards, Dirk

[thomas_jung · Accepted solution]

>is there a way to get the current space by SQL?

No that isn't set automatically. However an application at the Node.js or Java level could read it from the Environment and then set it in the SESSION_CONTEXT so it could be read via SQL.

>And one more, is it possible that the system creates in two different spaces a container with the same HDI-ContainerID?

Yes they could have the same container name. You can't specify the specific SCHEMA however unless both spaces point to two different MDC tenants.

[draschke · Accepted solution]

Thanks Thomas, it helps us a lot!