Create a table in the database
The default dbCreateTable() method calls sqlCreateTable() and
dbExecute().
Backends compliant to ANSI SQL 99 don't need to override it.
Backends with a different SQL syntax can override sqlCreateTable(),
backends with entirely different ways to create tables need to
override this method.
dbCreateTable(conn, name, fields, ..., row.names = NULL, temporary = FALSE)
conn |
A DBIConnection object, as returned by
|
name |
Name of the table, escaped with |
fields |
Either a character vector or a data frame. A named character vector: Names are column names, values are types.
Names are escaped with A data frame: field types are generated using
|
... |
Other arguments used by individual methods. |
row.names |
Must be |
temporary |
If |
The row.names argument is not supported by this method.
Process the values with sqlRownamesToColumn() before calling this method.
The argument order is different from the sqlCreateTable() method, the
latter will be adapted in a later release of DBI.
Other DBIConnection generics:
DBIConnection-class,
dbAppendTable(),
dbDataType(),
dbDisconnect(),
dbExecute(),
dbExistsTable(),
dbGetException(),
dbGetInfo(),
dbGetQuery(),
dbIsReadOnly(),
dbIsValid(),
dbListFields(),
dbListObjects(),
dbListResults(),
dbListTables(),
dbReadTable(),
dbRemoveTable(),
dbSendQuery(),
dbSendStatement(),
dbWriteTable()
con <- dbConnect(RSQLite::SQLite(), ":memory:") dbCreateTable(con, "iris", iris) dbReadTable(con, "iris") dbDisconnect(con)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.