DROP SPATIAL UNIT OF MEASURE [ IF EXISTS ] identifier 

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.

Must have DBA authority or be a member of the SYS_SPATIAL_ADMIN_ROLE.

None

• CREATE SPATIAL UNIT OF MEASURE statement
• Using spatial data

The following example drops a spatial unit of measure named TEST.

DROP SPATIAL UNIT OF MEASURE Test;