dbDropTable: Drop an existing table

In schardtbc/DBIExt: Extentsion for DBI; new Generics

Description

The sql generation uses the function 'sqlDropTable()' another S4 generic defined in this package. Default sql generation is appropriate for MariaDB and MySQL.

Usage

dbDropTable(con, name, ...)

Arguments

con	a DBConnection oject
name	a character string specifying the name of an existing DBMS table
primary_key	a character vector of column names which will form the primary key To specify a composite Primary Key for the 'symbol' and 'date' columns use primary_key = c("symbol","date" ) For a table with a Primary Key defined, each records must have a unqiue primary key. Attempts to 'INSERT' records with a duplicate Primary Key to an existing record in the DB will cause an ERROR

See Also

Other DBIConnection generics: dbAddIndex, dbAddPrimaryKey, dbDeleteAllRecords, dbReplaceInTable, dbUpdateTable

schardtbc/DBIExt documentation built on June 7, 2019, 2:39 p.m.