This function cleans up the tables created by the
CreateVocabMapTables() and
CreateVisitRollupTables()

DropMapAndRollupTables(connectionDetails, cdmSchema)

Arguments

connectionDetails

An R object of type
connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.

cdmSchema

The name of the database schema that will contain the Vocab mapping tables. Requires read and write permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'.

Details

This function assumes
CreateVocabMapTables() and
CreateVisitRollupTables() have already been run.