Reference and syntax for the DROP LOCATION statement.
Parameter | Description |
---|---|
<location_name> | The identifier of the location to remove. |
IF EXISTS | A parameter that suppresses the error if the location doesn’t exist. |
WITH FORCE | Forces the removal of the location even if it has dependent external tables. Warning: This option invalidates all dependent external tables. |
LOCATION
object from your Firebolt account:
LOCATION
object from your Firebolt account if it exists:
WITH FORCE
option to drop the location immediately regardless of dependencies.WITH FORCE
, the following apply:
WITH FORCE
.LOCATION
object from your Firebolt account without considering its dependencies:
Error Type | Cause | Resolution |
---|---|---|
Location Not Found or Unauthorized | The specified location does not exist or you lack permission to access it. | Use IF EXISTS to handle non-existent locations without error. |
Dependent Objects Exist | The location is referenced by one or more external tables. | Drop the dependent tables first or use WITH FORCE to bypass dependency checks. |
Invalid External Table | Attempting to query an external table after its location was removed using WITH FORCE . | Drop the invalid external table. |
IF EXISTS
to handle non-existent locations gracefully.