List Tables in the Current Database and Schema

Returns a lazy tibble of all tables that exist in the **current database** and **current schema** of the active connection. Queries the standard `information_schema.tables` view and filters to `current_database()` and `current_schema()`.

Usage

list_current_tables(.con)

Arguments

.con

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

Value

A `dbplyr` lazy tibble with columns: * `table_catalog` — the current database. * `table_schema` — the current schema. * `table_name` — each table name.

Details

- This function validates that the connection is valid with `validate_con()`. - Result is a `dbplyr` lazy table (`tbl_dbi`); call `collect()` to bring it into R.

See also

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