get_tables: List the available tables on the connection

In SCDB: Easily Access and Maintain Time-Based Versioned Data (Slowly-Changing-Dimension)

List the available tables on the connection

Description

List the available tables on the connection

Usage

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

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?

Value

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

Examples

  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)

SCDB documentation built on Oct. 4, 2024, 1:09 a.m.