DROP DATA SERVICE Statement

Enables you to drop a data service. Here is the syntax: 
DROP [DATA] SERVICE data-service-name [drop-disposition]

data-service-name

Specifies the name of the data service to drop.

drop-disposition

Specifies the drop disposition as one of the following values:

drop-disposition ::=
       {RESTRICT | CASCADE} [FORCE]

RESTRICT Specifies that the drop target is empty. This is the default value.
CASCADE Specifies that contained objects are dropped.
FORCE Specifies the optional FORCE keyword that will suppress error messages when the data service does not exist. This additional option does not affect the performance of the RESTRICT or CASCADE options.
Examples
drop DATA SERVICE ORACLE3
drop service "MYSQL_SERVICE" cascade force
drop data service ORACLE1 cascade
Copyright © SAS Institute Inc. All rights reserved.