List Tables in the Current Database and Schema

Source: R/utils-db.R

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

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