Drop a Table — delete_table • motherduck

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()