Returns a lazy tibble of all tables visible to the current connection by
querying information_schema.tables (across all catalogs/databases and
schemas).
list_all_tables(.con)A dbplyr lazy tibble with columns:
table_catalog — database/catalog name
table_schema — schema name
table_name — table name
A valid DBI connection (DuckDB / MotherDuck).
The result is a dbplyr lazy table (tbl_dbi). Use collect() to bring
results into R as a local tibble.
Other db-list:
list_all_databases(),
list_current_schemas(),
list_current_tables(),
list_extensions(),
list_fns(),
list_setting(),
list_shares()