createTable: Create Table

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

Create table sql.

Usage

createTable(pTableName, pColNames = NULL, pColTypes = NULL,
  pTableOptions = NULL, pPrimaryKey = pColNames[1], pFromTableName = NULL,
  pWithData = TRUE, pTemporary = getOption("temporaryFL"), pDrop = FALSE,
  pDatabase = getOption("ResultDatabaseFL"), pSelect = NULL, ...)

Arguments

pTableName
pColNames
pColTypes
pTableOptions
pPrimaryKey
pFromTableName
pWithData
pTemporary
pDrop
pDatabase
pSelect
...

Details

covers cases where table is created from other tables with and without data , temporary and permanent if usedbSendUpdate arg is passed in ... that is used in place of dbSendQuery

Value

The fully qualified table name for referring to this table.

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.