DROP SPATIAL REFERENCE SYSTEM [ IF EXISTS ] name 

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.

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

None

• CREATE SPATIAL REFERENCE SYSTEM statement
• ALTER SPATIAL REFERENCE SYSTEM statement
• Spatial data

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

DROP SPATIAL REFERENCE SYSTEM Test;