The drop service command removes a user-defined Web service from the current database. Both the metadata and the corresponding stored procedure are removed.
drop service service-name
is 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
You must undeploy a user-defined Web service before you can drop it. For details on the undeploy option, see sp_webservices on page 719.
