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().
list_current_tables(.con)A dbplyr lazy tibble with columns:
table_catalog — the current database.
table_schema — the current schema.
table_name — each table name.
A valid DBI connection (DuckDB / MotherDuck).
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.
Other db-list:
list_all_databases(),
list_all_tables(),
list_current_schemas(),
list_extensions(),
list_fns(),
list_setting(),
list_shares()