Create or drop table — createTable • bcputility

Create or drop table

Usage

createTable(connectargs, table, coltypes, ...)

dropTable(connectargs, table, ...)

checkTableExists(connectargs, table)

Arguments

connectargs: named list of connection arguments. See makeConnectArgs.
table: Name of the source table when importing from SQL Server. For specifying the schema in the table name see <schema>.<table> and if not specified the default is "dbo".
coltypes: character vector of data types with the column names as list/vector names. Use mapDataTypes or refer to for proper format.
...: arguments to pass to system2

Value

No return value. Operations from bcp are printed to console; see ... to redirect output