The drop service command removes a user-defined Web service from the current database. Both the metadata and the corresponding stored procedure are removed.
You must undeploy a user-defined Web service before
you can drop it. For details on the undeploy option
for sp_webservices, see “Using sp_webservices with user-defined Web services”.
drop service service-name
service-name – the name for the user-defined Web service. This name can be any name that is valid for a stored procedure. If you specify the name of an service that does not exist, an exception results. Also, you cannot drop a service that is currently in use by another session.
This example drops the user-defined Web service named sp_who_service:
drop service sp_who_service
