Learn R Programming

CDMConnector (version 2.0.0)

listTables: List tables in a schema

Description

DBI::dbListTables can be used to get all tables in a database but not always in a specific schema. listTables will list tables in a schema.

Usage

listTables(con, schema = NULL)

Value

A character vector of table names

Arguments

con

A DBI connection to a database

schema

The name of a schema in a database. If NULL, returns DBI::dbListTables(con).

Examples

Run this code
if (FALSE) {
con <- DBI::dbConnect(duckdb::duckdb(), dbdir = eunomiaDir())
listTables(con, schema = "main")
}

Run the code above in your browser using DataLab