DROP SPATIAL REFERENCE SYSTEM Statement

Go to Parameters

Go to Standards

Go to Permissions

Syntax

DROP SPATIAL REFERENCE SYSTEM [ IF EXISTS ] name

Parameters

(back to top)

• IF EXISTS – prevents an error from being returned when the DROP SPATIAL REFERENCE SYSTEM statement attempts to remove a spatial reference system that does not exist.

Standards

(back to top)

ANSI SQL–Compliance level: Transact-SQL extension.

Permissions

(back to top)

• MANAGE ANY SPATIAL OBJECT system privilege.
• DROP ANY OBJECT system privilege.
• You own the spatial references system.