sqlTableCreate: Create a simple table.

In rstats-db/SQL: Safely Generate Common SQL Strings

Description

Exposes interface to simple CREATE TABLE commands. The default method is ANSI SQL 99 compliant.

Usage

sqlTableCreate(con, table, fields, row.names = NA, temporary = FALSE, ...)

## S4 method for signature 'DBIConnection'
sqlTableCreate(con, table, fields, row.names = NA,
  temporary = FALSE...)

Arguments

con	A database connection.
table	Name of the table. Escaped with dbQuoteIdentifier.
fields	Either a character vector or a data frame. A named character vector: Names are column names, values are types. Names are escaped with dbQuoteIdentifier. Field types are unescaped. A data frame: field types are generated using dbDataType.
row.names	Either TRUE, FALSE, NA or a string. If TRUE, always translate row names to a column called "row_names". If FALSE, never translate row names. If NA, translate rownames only if they're a character vector. A string is equivalent to TRUE, but allows you to override the default name. For backward compatibility, NULL is equivalent to FALSE.
temporary	If TRUE, will generate a temporary table statement.
...	Other arguments used by individual methods.

DBI-backends

If you implement one method (i.e. for strings or data frames), you need to implement both, otherwise the S4 dispatch rules will be ambiguous and will generate an error on every call.

Examples

sqlTableCreate(ANSI(), "my-table", c(a = "integer", b = "text"))
sqlTableCreate(ANSI(), "my-table", iris)

# By default, character row names are converted to a row_names colum
sqlTableCreate(ANSI(), "mtcars", mtcars[, 1:5])
sqlTableCreate(ANSI(), "mtcars", mtcars[, 1:5], row.names = FALSE)

rstats-db/SQL documentation built on May 28, 2019, 3:35 a.m.