List Databases Visible to the Connection

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

Usage

list_all_databases(.con)

Arguments

.con

A valid DBI connection (DuckDB / MotherDuck).

Value

A dbplyr lazy tibble with one column: table_catalog.

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()