DROP SPATIAL UNIT OF MEASURE Statement

Drops a spatial unit of measurement.

Syntax

DROP SPATIAL UNIT OF MEASURE [ IF EXISTS ] identifier

Examples

Example – The following example drops a fictitious spatial unit of measure named Test.
```
DROP SPATIAL UNIT OF MEASURE Test; 
```

Usage

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.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Requires one of:

MANAGE ANY SPATIAL OBJECT system privilege.
DROP ANY OBJECT system privilege.
You own the spatial unit of measure