Drop a Table

Source: R/utils-db.R

Drops a table from the specified database and schema if it exists. Uses ⁠DROP TABLE IF EXISTS⁠ for safety and prints a CLI status report.

Usage

delete_table(.con, database_name, schema_name, table_name)

Arguments

.con

A valid DBI connection (DuckDB / MotherDuck).

database_name

Name of the database containing the table.

schema_name

Name of the schema containing the table.

table_name

Name of the table to drop.

Value

Invisibly returns NULL. Side effect: drops the table and prints CLI status messages.

See Also

Other db-manage: alter_table_schema(), copy_tables_to_new_location(), create_database(), create_if_not_exists_share(), create_or_replace_share(), create_schema(), create_table(), delete_and_create_schema(), delete_database(), delete_schema(), describe_share(), drop_share(), list_owned_shares(), list_shared_with_me_shares(), upload_database_to_md()