This function creates the all the required tables for the CDM.

CreateCDMTables(
  connectionDetails,
  cdmSchema,
  cdmVersion,
  outputFolder = NULL,
  createIndices = FALSE,
  sqlOnly = FALSE
)

Arguments

connectionDetails

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

cdmSchema

The name of the CDM database schema. Requires read and write permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.

cdmVersion

Your CDM version. Currently "5.3" and "5.4" are supported.

outputFolder

Location of the SQL scripts if sqlOnly = TRUE. Default is NULL.

createIndices

A boolean that determines whether or not to create indices on CDM tables after they are created.

sqlOnly

A boolean that determines whether to create the tables or generate SQL scripts. Default is FALSE.

Details

This function creates all the tables in a CDM by calling CommonDataModel::executeDdl(). Indices, if created, come from CommonDataModel::writeIndex(). Supported CDM versions and db dialects are determined by CommonDataModel::listSupportedVersions() and CommonDataModel::listSupportedDialects(), respectively.