dropAllScratchTables: Drop all possible scratch tables

In EHDEN/CatalogueExport: Exports Descriptive Statistics Summary for the EHDEN Database Catalogue

Description

Drop all possible scratch tables

Usage

dropAllScratchTables(
  connectionDetails,
  scratchDatabaseSchema,
  tempPrefix = "tmpach",
  numThreads = 1,
  tableTypes = "catalogueExport",
  outputFolder,
  verboseMode = TRUE
)

Arguments

connectionDetails	An R object of type connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.
scratchDatabaseSchema	string name of database schema that CatalogueExport scratch tables were written to.
tempPrefix	The prefix to use for the "temporary" (but actually permanent) CatalogueExport analyses tables. Default is "tmpach"
numThreads	The number of threads to use to run this function. Default is 1 thread.
tableTypes	The types of scratch tables to drop: catalogueExport
outputFolder	Path to store logs and SQL files
verboseMode	Boolean to determine if the console will show all execution steps. Default = TRUE

Details

Drop all possible CatalogueExport scratch tables

EHDEN/CatalogueExport documentation built on April 2, 2021, 5:13 p.m.