DROP SPATIAL UNIT OF MEASURE statement

Drops a spatial unit of measurement.

Syntax

DROP SPATIAL UNIT OF MEASURE [ IF EXISTS ] identifier

Remarks

Use the IF EXISTS clause if you do not want an error returned when the DROP SPATIAL UNIT OF MEASURE statement attempts to remove a spatial unit of measure that does not exist.

Privileges

You must be the owner of the spatial unit of measure, or have the MANAGE ANY SPATIAL OBJECT or DROP ANY OBJECT system privilege.

Side effects

None

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following example drops a fictitious spatial unit of measure named Test.

DROP SPATIAL UNIT OF MEASURE Test;