CURRENT SCHEMA

CURRENT SCHEMA returns the schema name used to qualify unqualified database object references.

CURRENT SCHEMA and CURRENT SQLID are synonyms.

Syntax

CURRENT SCHEMA

– or, alternatively:

CURRENT SQLID

Results

The returned value is a string with a length of up to 128 characters.

Examples

splice> VALUES(CURRENT SCHEMA);
1
-------------------------------------------------------
SPLICE

1 row selected