List All Tables Visible to the Connection

Returns a lazy tibble of all tables visible to the current connection by querying `information_schema.tables` (across all catalogs/databases and schemas).

Usage

list_all_tables(.con)

Arguments

.con

A valid `DBI` connection (DuckDB / MotherDuck).

Value

A `dbplyr` lazy tibble with columns: * `table_catalog` — database/catalog name * `table_schema` — schema name * `table_name` — table name

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