DROP APPLICATION SERVICE

Removes the specified Application Service from the current or specified schema and stops its containers.

See also:

CREATE APPLICATION SERVICE , ALTER APPLICATION SERVICE , DESCRIBE APPLICATION SERVICE , SHOW APPLICATION SERVICES

Syntax

DROP APPLICATION SERVICE [ IF EXISTS ] <name>

Parameters

name

Specifies the identifier of the Application Service to drop.

Access control requirements

Your role must have the following privileges on objects:

PrivilegeObject
OWNERSHIPApplication Service that you remove

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes

  • Dropping an Application Service stops and deletes its containers. The underlying package in the artifact repository isn’t affected.
  • Grants on the service are revoked automatically when the service is dropped.
  • When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

Examples

DROP APPLICATION SERVICE IF EXISTS my_app;