current_schemas()

Returns list of schemas. Pass a parameter of True to include implicit schemas

Arguments & returns

current_schemas(include_implicit)

Scalar
Overload link include_implicit Returns
#01 BOOLEAN VARCHAR[]

Example

current_schemas example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

Snowflakecurrent_schemas()

SELECT CURRENT_SCHEMAS()
In DuckDB
SELECT CURRENT_SCHEMAS(TRUE)

SQLGlot example ↗