DROP LOCATION

Purpose

This statement is used to delete a location object.

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 MySQL-compatible mode.

Syntax

DROP LOCATION location_name;

Parameters

Examples

Drop the location object test_location_local.

obclient> DROP LOCATION test_location_local;

References

For information about how to view the information of a location object in the current tenant, see SHOW.