Learn R Programming

motherduck (version 0.2.0)

list_all_databases: List Databases Visible to the Connection

Description

Returns a lazy tibble of distinct database (catalog) names visible through the current connection, using information_schema.tables.

Usage

list_all_databases(.con)

Value

A dbplyr lazy tibble with one column: table_catalog.

Arguments

.con

A valid DBI connection (DuckDB / MotherDuck).

Details

The result is a dbplyr lazy table (tbl_dbi). Use dplyr::collect() to bring results into R as a local tibble.

See Also

Other db-list: list_all_tables(), list_current_schemas(), list_current_tables(), list_extensions(), list_fns(), list_setting(), list_shares()