createCharacterizationTables {Characterization} | R Documentation |
Create the results tables to store characterization results into a database
Description
This function executes a large set of SQL statements to create tables that can store results
Usage
createCharacterizationTables(
connectionDetails,
resultSchema,
targetDialect = "postgresql",
deleteExistingTables = TRUE,
createTables = TRUE,
tablePrefix = "c_",
tempEmulationSchema = getOption("sqlRenderTempEmulationSchema")
)
Arguments
connectionDetails |
The connectionDetails to a database created by using the
function |
resultSchema |
The name of the database schema that the result tables will be created. |
targetDialect |
The database management system being used |
deleteExistingTables |
If true any existing tables matching the Characterization result tables names will be deleted |
createTables |
If true the Characterization result tables will be created |
tablePrefix |
A string appended to the Characterization result tables |
tempEmulationSchema |
The temp schema used when the database management system is oracle |
Details
This function can be used to create (or delete) Characterization result tables
Value
Returns NULL but creates the required tables into the specified database schema.
See Also
Other Database:
createSqliteDatabase()
,
insertResultsToDatabase()
Examples
# create sqlite database
charResultDbCD <- createSqliteDatabase()
# create database results tables
createCharacterizationTables(
connectionDetails = charResultDbCD,
resultSchema = 'main'
)