Skip to contents

Drop a DuckLake view

Source: R/views.R
drop_view.Rd

Removes a view from the lake with DROP VIEW. Only the stored query is dropped; the tables it reads are untouched.

Usage

drop_view(view_name)

Arguments

view_name

The view to drop.

Value

Invisibly returns NULL.

See also

create_view()

Other table operations: add_data_files(), create_schema(), create_table(), create_view(), drop_schema(), ducklake_exec(), get_ducklake_table(), get_metadata_table(), list_ducklake_tables(), replace_table(), show_ducklake_query()

Examples

lake_dir <- tempfile("dropview_lake_")
dir.create(lake_dir)
attach_ducklake("dropview_lake", lake_path = lake_dir)
create_table(mtcars, "cars")

get_ducklake_table("cars") |>
  dplyr::filter(cyl == 4) |>
  create_view("v_efficient_cars")
#> Created view "v_efficient_cars".

drop_view("v_efficient_cars")
#> Dropped view "v_efficient_cars".

detach_ducklake("dropview_lake", shutdown = TRUE)
unlink(lake_dir, recursive = TRUE)