DROP SPATIAL UNIT OF MEASURE Statement

Syntax

DROP SPATIAL UNIT OF MEASURE [ IF EXISTS ] identifier

Parameters

• IF EXISTS – prevents an error from being returned when the DROP SPATIAL UNIT OF MEASURE statement attempts to remove a spatial unit of measure that does not exist.

Examples

• Example – the following example drops a fictitious spatial unit of measure named Test:

  DROP SPATIAL UNIT OF MEASURE Test; 

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

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