list tables

Work around connection v.s. handle issues https://github.com/tidyverse/dplyr/issues/2849

replyr_list_tables(con)

Arguments

con	connection

Value

list of tables names

Examples

if (requireNamespace("RSQLite", quietly = TRUE)) {
   my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
   RSQLite::initExtension(my_db)
  d <- replyr_copy_to(my_db, data.frame(x=c(1,2)), 'd',
                      overwrite=TRUE, temporary=TRUE)
  print(d)
  print(replyr_list_tables(my_db))
  DBI::dbDisconnect(my_db)
}
#> # Source:   table<d> [?? x 1]
#> # Database: sqlite 3.30.1 [:memory:]
#>       x
#>   <dbl>
#> 1     1
#> 2     2
#> [1] "d"            "sqlite_stat1" "sqlite_stat4"