SCDB (version 0.5.1)

get_tables: List the available tables on the connection

Description

List the available tables on the connection

Usage

get_tables(conn, pattern = NULL, show_temporary = TRUE)

Value

A data.frame containing table names including schema (and catalog when available) in the database.

Arguments

conn

(DBIConnection(1))
Connection object.

pattern

(character(1))
Regex pattern with which to subset the returned tables.

show_temporary

(logical(1))
Should temporary tables be listed?

Examples

if (FALSE) { # requireNamespace("RSQLite", quietly = TRUE)
  conn <- get_connection()

  dplyr::copy_to(conn, mtcars, name = "my_test_table_1", temporary = FALSE)
  dplyr::copy_to(conn, mtcars, name = "my_test_table_2")

  get_tables(conn, pattern = "my_[th]est")
  get_tables(conn, pattern = "my_[th]est", show_temporary = FALSE)

  close_connection(conn)
}