sqlDrop: Deletion Operations on Tables in ODBC databases

View source: R/sql.R

sqlDropR Documentation

Deletion Operations on Tables in ODBC databases


sqlClear deletes all the rows of the table sqtable.

sqlDrop removes the table sqtable (if permitted).


sqlClear(channel, sqtable, errors = TRUE)

sqlDrop(channel, sqtable, errors = TRUE)



connection object as returned by odbcConnect.


character string: a database table name accessible from the connected DSN. This can be a ‘dotted’ name of the form schema.table.


logical: if TRUE halt and display error, else return -1.


These submit ‘⁠TRUNCATE TABLE⁠’ and ‘⁠DROP TABLE⁠’ SQL queries respectively.

‘Dotted’ table names are allowed on systems that support them but the existence of the table is not checked and so attempting these operations on a non-existent table will give a low-level error. (This can be suppressed by opening the connection with interpretDot = FALSE.)

The default ‘drop’ behaviour in Oracle is to move the table to the ‘recycle bin’: use

  sqlQuery(channel, "PURGE recyclebin")

to empty the recycle bin.

The current user might not have privileges to allow these operations, and Actual Technologies' Mac OS X SQLite driver has a bug causing them silently to fail.


If errors = FALSE, a numeric value, invisibly. Otherwise a character string or invisible().


Michael Lapsley and Brian Ripley

See Also

odbcConnect, sqlQuery, sqlFetch, sqlSave, sqlTables, odbcGetInfo

RODBC documentation built on Nov. 25, 2023, 5:07 p.m.