CURRENT TENANT special register

The CURRENT TENANT (or CURRENT_TENANT) special register specifies a VARCHAR(128) value that identifies the tenant currently in use for this session.

The tenant determines what user-defined database objects are considered for resolution of object references made within a session. The initial value of CURRENT TENANT is SYSTEM, which represents the default tenant for the database. The value can be changed by invoking the SET TENANT statement.

Example

The following example shows the command syntax for setting the tenant for the current session to ACCOUNTS:

  SET CURRENT TENANT = 'ACCOUNTS’