Categories: System

CURRENT_SCHEMA

Returns the path/schema in use by the current session. This function cannot be used in a reflection.

Syntax

CURRENT_SCHEMA() → varchar

Examples

CURRENT_SCHEMA example

SELECT CURRENT_SCHEMA
-- Samples."samples.dremio.com"

Usage Notes

This function must be called without parentheses.