Drop table/view/schema.

Drop a table, a view or a schema.

Usage

dbDrop(
  conn,
  name,
  type = c("table", "schema", "view", "materialized view"),
  ifexists = FALSE,
  cascade = FALSE,
  display = TRUE,
  exec = TRUE
)

Arguments

conn

A connection object.

name

A character string specifying a PostgreSQL table, schema, or view name.

type

The type of the object to drop, either "table", "schema", "view", or "materialized view".

ifexists

Do not throw an error if the object does not exist. A notice is issued in this case.

cascade

Automatically drop objects that depend on the object (such as views).

display

Logical. Whether to display the query (defaults to TRUE).

exec

Logical. Whether to execute the query (defaults to TRUE).

Value

If exec = TRUE, returns (invisibly) TRUE if the table/schema/view was successfully dropped.

See also

The PostgreSQL documentation: http://www.postgresql.org/docs/current/static/sql-droptable.html, http://www.postgresql.org/docs/current/static/sql-dropview.html, http://www.postgresql.org/docs/current/static/sql-dropschema.html

Author

Mathieu Basille mathieu@basille.org

Examples

## examples use a dummy connection from DBI package
conn <- DBI::ANSI()
dbDrop(conn, name = c("schema", "view_name"), type = "view", exec = FALSE)
#> ℹ DROP VIEW "schema"."view_name";
#> ✖ Query not executed
dbDrop(conn, name = "test_schema", type = "schema", cascade = "TRUE", exec = FALSE)
#> ℹ DROP SCHEMA "test_schema" CASCADE;
#> ✖ Query not executed