ST_DROP_SRS procedure

Use this stored procedure to drop a spatial reference system.

When this stored procedure is processed, information about the spatial reference system is removed from the SYSGEO.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.

Restriction: You cannot drop a spatial reference system if a spatial column that uses that spatial reference system is registered.
Important:
Use care when you use this stored procedure. If you use this stored procedure to drop a spatial reference system, and if any spatial data is associated with that spatial reference system, you can no longer perform spatial operations on the spatial data.

Authorization

The user ID under which the stored procedure is invoked must have SYSGEOADM authority.

Syntax

Read syntax diagramSkip visual syntax diagramST_DROP_SRS(srs_name)

Parameter descriptions

srs_name
Identifies the spatial reference system. You must specify a non-null value for this parameter.

The data type of this parameter is VARCHAR(128).

Example

This example shows how to invoke the ST_DROP_SRS stored procedure. This example uses a Db2® CALL command to delete a spatial reference system named SRSDEMO: 


call ST_DROP_SRS('SRSDEMO')

  Return Status = 0

call ST_DROP_SRS('SRSDEMO')
SQL0204N  "SRSDEMO" is an undefined name.  SQLSTATE=42704