drop_table: Drop a table from the database
In nhsbsa-data-analytics/nhsbsaR: NHSBSA R package

drop_table

R Documentation

Drop a table from the database

Description

Drop a database table in user's own schema.

Usage

drop_table(table_name, conn = con, purge = TRUE, silent = F)

Arguments

`table_name`	name of the table in SQL database
`conn`	connection object created using `nhsbsaR::con_nhsbsa()`
`purge`	logical. If `TRUE`, releases space associated with the table back to the tablespace for use by other tables/objects. If `FALSE`, the table and its dependent objects are placed into recycle bin and continue to count toward the user's space quota. Tables in the recycle bin can be brought back using a `⁠FLASHBACK TABLE⁠` statement.
`silent`	If `TRUE`, does not output info messages `⁠Table dropped⁠` or `⁠Table does not exist⁠` to the console.

Examples

## Not run: 
# If connection object is named `con`
drop_table("INT646_TABLE_DB")
# If connection object is not named `con`
drop_table("INT646_TABLE_DB", conn = my_connection_name)

## End(Not run)

nhsbsa-data-analytics/nhsbsaR documentation built on Jan. 25, 2025, 8:54 a.m.