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_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 `collect()` to bring results into R as a local tibble.

See also

[dbplyr::tbl()], [DBI::dbConnect()]