6.34 SDO_NET.DROP_FEATURE_LAYER

Format

SDO_NET.DROP_FEATURE_LAYER(
     network_name       IN VARCHAR2,
     feature_layer_name IN VARCHAR2,
     drop_tables        IN BOOLEAN DEFAULT FALSE);

Description

Drops (deletes) a feature layer.

Parameters

network_name

Name of the network containing the feature layer to be dropped.

feature_layer_name

Name of the feature layer to be dropped.

drop_tables

Controls whether all relevant tables are deleted along with the feature layer metadata: TRUE drops the feature table, feature element relationships table, and feature hierarchy table, and deletes the feature layer metadata; FALSE (the default) deletes the feature layer metadata but does not drop the feature table, feature element relationships table, and feature hierarchy table.

Usage Notes

(None.)

Examples

The following example drops the POI feature layer in the GRID network, and (because drop_tables is true) drops the feature table, feature element relationships table, and feature hierarchy table, and deletes the feature layer metadata

EXECUTE sdo_net.drop_feature_layer('GRID', 'POI', true);