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

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