Database & utility
Scalar
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
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
In other engines
Snowflakecurrent_schemas()
SELECT CURRENT_SCHEMAS()
SELECT CURRENT_SCHEMAS(TRUE)