Dropping a web service causes the subsequent requests made for that service to return a 404 Not Found HTTP status message. All unresolved requests, intended or unintended, are processed if a root web service exists.
Execute the following SQL statement to drop a web service named SampleWebService:
DROP SERVICE SampleWebService;