DROP DESCRIPTOR_SOURCE

Syntax

DROP DESCRIPTOR_SOURCE descriptor_source_name;

Description

Permanently removes all Descriptors that were imported from a Descriptor Source.

DROP DESCRIPTOR_SOURCE cannot be undone. Use it with care!

Arguments

descriptor_source_name

Name of the Descriptor Source to remove of its corresponding descriptors. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Examples

Drop a Descriptor Source

The following demonstrates that when the Descriptor Source pageviews is dropped, the descriptors pageviews.PageviewsKey and pageviews.Pageviews that were extracted from it are also removed from the system:

<no-db>/<no-store># LIST DESCRIPTORS;
           Name           
--------------------------
  pageviews.PageviewsKey  
  pageviews.Pageviews     

<no-db>/<no-store># DROP DESCRIPTOR_SOURCE pageviews;
<no-db>/<no-store># LIST DESCRIPTORS;
  Name  
--------