RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-drop-volume below:

DROP VOLUME | Databricks Documentation

DROP VOLUME

Applies to: Databricks SQL Databricks Runtime 13.3 LTS and above Unity Catalog only

Deletes the specified volume.

When you delete a managed volume, the files stored in this volume are retained for 7 days. After 7 days, the data is marked for deletion from your cloud tenant during regular maintenance operations.

If an external volume is dropped, the metadata about the volume is removed from the catalog, but the underlying files are not deleted.

To drop a volume you must have the MANAGE privilege on the volume, be its owner, or be the owner of the schema, catalog, or metastore the volume resides in.

warning

A dropped volume cannot be recovered.

Syntaxâ

DROP VOLUME [ IF EXISTS ] volume_name

Parameterâ

IF EXISTS

If specified, no error is thrown when the volume does not exist.
volume_name

The name of the volume to be dropped. If the volume cannot be found Databricks raises an error.

Examplesâ

SQL

â Drop a volume named 'my_volume'
> DROP VOLUME my_volume
  OK

â Drop a volume named `my_volume` under catalog `my_catalog` and schema `my_schema
> DROP VOLUME my_catalog.my_schema.my_volume
  OK

â The volume must exist
> DROP VOLUME my_volume
  Error

â Drop a volume named `my_volume` only if it exists
> DROP VOLUME IF EXISTS my_volume
  OK