Returns a lazy tibble of all schemas in the current database of the
connection. Queries information_schema.schemata and filters to the
current database (catalog_name = current_database()).
list_current_schemas(.con)A dbplyr lazy tibble with columns:
catalog_name — the current database name.
schema_name — each schema within that database.
A valid DBI connection (DuckDB / MotherDuck).
This function assumes the connection is valid (checked with
validate_con()).
Returns a dbplyr lazy table; use collect() to bring the result into R.
Other db-list:
list_all_databases(),
list_all_tables(),
list_current_tables(),
list_extensions(),
list_fns(),
list_setting(),
list_shares()