Purpose
This statement is used to drop a location object.
Note
For OceanBase Database V4.4.x, the DROP LOCATION statement is supported starting from V4.4.1.
Privilege requirements
To execute the DROP LOCATION statement, the current user must have the CREATE LOCATION privilege. For more information about privileges in OceanBase Database, see Privilege classification in Oracle-compatible mode.
Syntax
DROP LOCATION location_name;
Parameters
| Parameter | Description |
|---|---|
| location_name | The name of the location object to be dropped. |
Examples
Drop the location object test_location_local.
obclient> DROP LOCATION test_location_local;
References
For information about how to view location objects in the current tenant, see SHOW.