sqliteBuildTableDefinition

dbBuildTableDefinition

The output SQL statement is a simple <code>CREATE TABLE</code> suitable for
<code>dbGetQuery</code>

internal

Embeds the SQLite database engine in R and provides an
interface compliant with the DBI package. The source for the SQLite
engine and for various extensions in a recent version is included.
System libraries will never be consulted because this package relies
on static linking for the plugins it includes; this also ensures a
consistent experience across all installations.

Kirill M<c3><bc>ller

RSQLite

SQLite Interface for R

Kirill Müller

Hadley Wickham

Seth Falcon

D. Richard Hipp

Dan Kennedy

Joe Mistachkin

 SQLite Authors

Liam Healy

R Consortium 

 RStudio

sqliteBuildTableDefinition function

<dl><dt>con</dt>
<dd>A database connection.</dd>
<dt>name</dt>
<dd>Name of the new SQL table</dd>
<dt>value</dt>
<dd>A data.frame, for which we want to create a table.</dd>
<dt>field.types</dt>
<dd>Optional, named character vector of the types for each
field in <code>value</code></dd>
<dt>row.names</dt>
<dd>Logical. Should row.name of <code>value</code> be exported as a
<code>row_names</code> field? Default is <code>TRUE</code></dd></dl>

Arguments

Build the SQL CREATE TABLE definition as a string — sqliteBuildTableDefinition

<dl>

<dt>con</dt>
<dd>A database connection.</dd>


<dt>name</dt>
<dd>Name of the new SQL table</dd>


<dt>value</dt>
<dd>A data.frame, for which we want to create a table.</dd>


<dt>field.types</dt>
<dd>Optional, named character vector of the types for each
field in <code>value</code></dd>


<dt>row.names</dt>
<dd>Logical. Should row.name of <code>value</code> be exported as a
<code>row_names</code> field? Default is <code>TRUE</code></dd>

</dl>

Build the SQL CREATE TABLE definition as a string

sqliteBuildTableDefinition: Build the SQL CREATE TABLE definition as a string

Description

Usage

Value

Arguments