showTables: List Tables in Catalog/Schema

Description Usage Arguments Examples

View source: R/showTables.R

Description

This function returns a list of all tables in defined Catalog/Schema

Usage

1

Arguments

conn

The connection to the database

pattern

optional SQL pattern for filtering table names, e.g. ‘%test%’

...

currently ignored

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
## Not run: 
require(DBI)
conn <- dbConnect(DoordaHost(),
                 user='username',
                 password='password',
                 catalog='doordastats_snapshot',
                 schema='doordastats_snapshot')

table = showTables(conn, "eng_%")

## End(Not run)

Doorda/doorda-r-sdk documentation built on Feb. 25, 2020, 2:59 p.m.