dbBuildTableDefinition {RMySQL} | R Documentation

## 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

### Details

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

### Value

An SQL string

### 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`.

[Package RMySQL version 0.6-0 Index]