Skip to contents

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