List All Tables Visible to the Connection

Source: R/utils-db.R

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

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