Build the SQL CREATE TABLE definition as a string
The output SQL statement is a simple CREATE TABLE with suitable for
dbGetQuery
mysqlBuildTableDefinition( dbObj, name, obj, field.types = NULL, row.names = TRUE, ... )
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
|
row.names |
logical, should row.name of |
... |
reserved for future use |
An SQL string
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.