DROP SPATIAL REFERENCE SYSTEM statement

Drops a spatial reference system.

Syntax

DROP SPATIAL REFERENCE SYSTEM [ IF EXISTS ] name

Remarks

Use the IF EXISTS clause if you do not want an error returned when the DROP SPATIAL REFERENCE SYSTEM statement attempts to remove a spatial reference system that does not exist.

Privileges

You must be the owner, or have the MANAGE ANY SPATIAL OBJECT or DROP ANY OBJECT system privilege.

Side effects

None

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following example drops a fictitious spatial reference system named Test.

DROP SPATIAL REFERENCE SYSTEM Test;