.github/drop_tables.R

library(DBI)

devtools::install()

pg <- dbConnect(odbc::odbc(), "PostgreSQL")
lapply(dbListTables(pg), dbRemoveTable, conn = pg)

mysql <- dbConnect(odbc::odbc(), "MySQL")
lapply(dbListTables(mysql), dbRemoveTable, conn = mysql)
rstats-db/odbc documentation built on May 15, 2024, 9:45 a.m.