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.

Must have DBA authority.

None

• CREATE SPATIAL REFERENCE SYSTEM statement
• ALTER SPATIAL REFERENCE SYSTEM statement
• Using spatial data

The following example drops a spatial reference system named TEST.

DROP SPATIAL REFERENCE SYSTEM Test;