drop service

The drop service command removes a user-defined Web service from the current database. Both the metadata and the corresponding stored procedure are removed.

Syntax

drop service service-name

Parameters

Examples

Usage

You must undeploy a user-defined Web service before you can drop it.

See also:
  • Web Services Users Guide

  • sp_webservices in Reference Manual: Procedures

Permissions

The permission checks for drop service differ based on your granular permissions settings.

SettingDescription
Enabled

With granular permissions enabled, you must be the service owner or a user with drop any procedure privilege.

Disabled

With granular permissions disabled, you must be a user with sa_role.

Related reference
create service