37.4 DELETE_GEOM_METADATA Procedure
This procedure deletes a spatial metadata record.
Syntax
APEX_SPATIAL.DELETE_GEOM_METADATA (
p_table_name IN VARCHAR2,
p_column_name IN VARCHAR2,
p_drop_index IN BOOLEAN DEFAULT FALSE );
Parameters
Table 37-4 DELETE_GEOM_METADATA Parameters
Parameter | Description |
---|---|
|
Name of the feature table. |
|
Name of the column of type |
|
If TRUE (default is FALSE), drop the spatial index on the column. |
Example
This example deletes metadata on column CITIES.SHAPE
and drops the spatial index on this column.
begin
apex_spatial.delete_geom_metadata (
p_table_name => 'CITIES',
p_column_name => 'SHAPE',
p_drop_index => true );
end;
Parent topic: APEX_SPATIAL