Retrieve Metadata for One or More Tables

Returns catalog (database), schema, and table information for one or more tables visible to the connection by querying `information_schema.tables`.

Usage

return_table_attributes(.con, table_name)

Arguments

.con

A valid `DBI` connection (DuckDB / MotherDuck).

table_name

Character vector of one or more table names to look up.

Value

A local tibble (data frame) with columns: * `table_catalog` — database/catalog name * `table_schema` — schema name * `table_name` — the matching table names

Details

- Accepts one or more table names and returns their associated `table_catalog`, `table_schema`, and `table_name` if found. - Uses `information_schema.tables` to look up metadata.

See also

[DBI::dbGetQuery()], [information_schema.tables]