Learn R Programming
RMySQL (version 0.9-3)

dbBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

Description

Build the SQL CREATE TABLE definition as a string for the input data.frame

Usage

dbBuildTableDefinition(dbObj, name, obj, field.types = NULL, row.names = TRUE, ...)

Arguments

dbObj
any DBI object (used only to dispatch according to the engine (e.g., MySQL, Oracle, PostgreSQL, SQLite)
name
name of the new SQL table
obj
an R object coerceable to data.frame for which we want to create a table
field.types
optional named list of the types for each field in obj
row.names
logical, should row.name of value be exported as a row_names field? Default is TRUE
...
reserved for future use

Value

  • An SQL string

Details

The output SQL statement is a simple CREATE TABLE with suitable for dbGetQuery

References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

MySQL, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbReadTable.