DROP SERVICE

Remove a service from the database.

Syntax
      DROP SERVICE service [;]
	  
Key
   service     The service to drop. 

Dropping a service will delete any messages currently queued for that service, the remote side of any open conversations using the service will receive an error from the Service Broker.

Example

DROP SERVICE [//ss64.com/TestService] ;

"We cheat the other guy and pass the savings on to you" ~ sign outside US car dealership

Related commands:

CREATE SERVICE
ALTER SERVICE