-
Notifications
You must be signed in to change notification settings - Fork 75
/
Copy pathCreateCDMTables.Rd
41 lines (36 loc) · 1.55 KB
/
CreateCDMTables.Rd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
% Generated by roxygen2: do not edit by hand
% Please edit documentation in R/CreateCDMTables.r
\name{CreateCDMTables}
\alias{CreateCDMTables}
\title{Create Common Data Model Tables.}
\usage{
CreateCDMTables(
connectionDetails,
cdmSchema,
cdmVersion,
outputFolder = NULL,
createIndices = FALSE,
sqlOnly = FALSE
)
}
\arguments{
\item{connectionDetails}{An R object of type\cr\code{connectionDetails} created using the
function \code{createConnectionDetails} in the
\code{DatabaseConnector} package.}
\item{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'.}
\item{cdmVersion}{Your CDM version. Currently "5.3" and "5.4" are supported.}
\item{outputFolder}{Location of the SQL scripts if sqlOnly = TRUE. Default is NULL.}
\item{createIndices}{A boolean that determines whether or not to create indices on CDM tables after they are created.}
\item{sqlOnly}{A boolean that determines whether to create the tables or generate SQL scripts. Default is FALSE.}
}
\description{
This function creates the all the required tables for the CDM.
}
\details{
This function creates all the tables in a CDM by calling \code{CommonDataModel::executeDdl()}.
Indices, if created, come from \code{CommonDataModel::writeIndex()}.
Supported CDM versions and db dialects are determined by \code{CommonDataModel::listSupportedVersions()}
and \code{CommonDataModel::listSupportedDialects()}, respectively.
}