as_sql: Generate an SQL CREATE TABLE Statement From a tabde Table...

In s-fleck/tabde: Define and Check The Structure of Data Frames and Database Tables

Description

This does not perform any sanity check on the input data. col_name and sql_type must be compatible with the DBMS that you want to use.

Usage

as_sql(x, ...)

## S3 method for class 'table_design_sql'
as_sql(x, tname, ...)

Arguments

x	any R object
...	passes on to methods
tname	character scalar. name of target table

Value

character scalar. An SQL CREATE TABLE statement.

Examples

td <- tabde_sql(
  col_name = c("numbers", "letters"),
  col_type = c("integer", "character"),
  sql_type = c("smallint", "varchar(255)")
)

as_sql(td, "test_table")

s-fleck/tabde documentation built on April 4, 2021, 10:11 p.m.