db2se drop_srs command

The db2se drop_srs command deletes a spatial reference system definition.

The information about the spatial reference system is no longer available through the DB2GSE.ST_SPATIAL_REFERENCE_SYSTEMS catalog view.

Authorization

The user ID has DBADM and DATAACCESS authority on the spatially enabled database to run this command.

Command syntax

db2se drop_srs command

Read syntax diagramSkip visual syntax diagramdrop_srsdatabase_name-userIduser_id-pwpassword -srsNamesrs_name

Command parameters

Where:
database_name
Specifies the name of the database for which you want to delete a spatial reference system definition.
-userId user_id
Specifies the database user ID that has DATAACCESS authority on the database indicated by database_name.
-pw password
Specifies the password for user_id.
-srsName srs_name
Identifies the spatial reference system that you want to delete. The srs_name value is converted to uppercase unless you enclose it in double quotation marks.

Usage notes

If you registered spatial columns that use a spatial reference system, you cannot drop that spatial reference system.

Examples

The following example drops a spatial reference system named MYSRS.

db2se drop_srs mydb -srsName mysrs