DROP EXTERNAL LOCATION

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above

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 

> DROP EXTERNAL LOCATION some_location;