Show TOC

DROP SPATIAL REFERENCE SYSTEM StatementLocate this document in the navigation structure

Drops a spatial reference system.

Quick Links:

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)

Requires one of:
  • MANAGE ANY SPATIAL OBJECT system privilege.
  • DROP ANY OBJECT system privilege.
  • You own the spatial references system.