DROP EXTERNAL LOCATION

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

Drops an external location. An exception is thrown if the location does not exist in the metastore. To drop an external location you must have the MANAGE privilege on the external location or be its owner.

Syntax

DROP EXTERNAL LOCATION [ IF EXISTS ] location_name

Parameters

• IF EXISTS

  If specified, no exception is thrown when the location does not exist.

• location_name

  The name of an existing location in the metastore. If the name does not exist, an exception is thrown unless IF EXISTS has been specified.

Examples

SQL

> DROP EXTERNAL LOCATION some_location;

Related articles

• CREATE EXTERNAL LOCATION
• DESCRIBE EXTERNAL LOCATION
• External locations and storage credentials
• SHOW EXTERNAL LOCATIONS