db_schema_drop: Remove a schema from a database
Description
![[Experimental]](figures/lifecycle-experimental.svg?package=dm&version=0.2.8)
db_schema_drop() deletes a schema from the database.
For certain DBMS it is possible to force the removal of a non-empty schema, see below.
Usage
db_schema_drop(con, schema, force = FALSE, ...)Arguments
An object of class "src" or "DBIConnection".
Class character or SQL (cf. Details), name of the schema
Boolean, default FALSE. Set to TRUE to drop a schema and
all objects it contains at once. Currently only supported for Postgres.
Passed on to the individual methods.
Value
NULL invisibly.
Details
Methods are not available for all DBMS.
An error is thrown if no schema of that name exists.
The argument schema (and dbname for MSSQL) can be provided as SQL objects.
Keep in mind, that in this case it is assumed that they are already correctly quoted as identifiers.
Additional arguments are:
dbname: supported for MSSQL. Remove a schema from a different database on the connected MSSQL-server; default: database addressed bycon.
See Also
Other schema handling functions:
db_schema_create(),
db_schema_exists(),
db_schema_list()