DROP APPLICATION PACKAGE

Removes an application package from the system in the Native Apps Framework.

See also:

ALTER APPLICATION PACKAGE, CREATE APPLICATION PACKAGE, SHOW APPLICATION PACKAGES,

Syntax

DROP APPLICATION PACKAGE <name>
Copy

Parameters

name

Specifies the identifier for the database to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes

  • An application package can only be dropped if it is not currently associated with a listing.

  • After you run this command, the application package is dropped and becomes unavailable within the provider account.

    Any application created from the application package remains visible to the consumer, but is otherwise inaccessible. Any attempt to access the application results in an error indicating the application package has been removed.

  • A consumer must explicitly run DROP APPLICATION to ensure that objects owned by the application have been appropriately transferred to other roles or removed.

Examples

DROP APPLICATION PACKAGE hello_snowflake_app;
Copy
+-------------------------------------------+
| status                                    |
|-------------------------------------------|
| hello_snowflake_app successfully dropped. |
+-------------------------------------------+