ST_UNREGISTER_SPATIAL_COLUMN procedure

Use this stored procedure to remove the registration of a spatial column.

The stored procedure removes the registration by removing the association of the spatial reference system with the spatial column. The ST_GEOMETRY_COLUMNS catalog view continues to contain the spatial column, but the column is no longer associated with any spatial reference system.

Authorization

The user ID under which this stored procedure is invoked must hold execution privilege on the procedure and one of the following authorities or privileges:
  • DBADM authority
  • CONTROL privilege on this table

Syntax

Read syntax diagramSkip visual syntax diagramST_UNREGISTER_SPATIAL_COLUMN( table_schemanull,table_name,column_name, )

Parameter descriptions

table_schema
Names the schema to which the table that is specified in the table_name parameter belongs. Although you must specify a value for this parameter, the value can be null. If this parameter is null, the value in the CURRENT SCHEMA special register is used as the schema name for the table or view.

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

table_name
Specifies the unqualified name of the table that contains the column that is specified in the column_name parameter. You must specify a non-null value for this parameter.

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

column_name
Names the spatial column that you want to unregister. You must specify a non-null value for this parameter.

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

Example

This example uses a Db2®">CALL command to unregister the spatial column named LOCATION in the table named CUSTOMERS: 

call ST_UNREGISTER_SPATIAL_COLUMN(NULL,'CUSTOMERS','LOCATION')
>