DROP LISTING

Removes the specified listing from the system and immediately revokes access for all consumers.

See also:

Syntax

DROP LISTING <name>
Copy

Parameters

name

Specifies the identifier for the listing 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

  • Only the listing owner, the role with the OWNERSHIP privilege on the listing, has the privileges to drop a listing. Executing this command with any other role returns an error.

  • Dropped listings cannot be recovered; they must be recreated.

  • Dropping a listing automatically invokes the retirement process for all public and monetized listings. Additionally, for other listing types the listing is dropped immediately, and all consumer access automatically revoked.

Important

Before dropping a listing, ensure that:

  • The listing is in state DRAFT or UNPUBLISH.

    Refer to ALTER LISTING for details on changing listing state.

  • Previously published listings are not be mounted by any consumers.

Examples

DROP LISTING IF EXISTS MY_LISTING
Copy
+----------------------------------+
| status                           |
|----------------------------------|
| MY_LISTING successfully dropped. |
+----------------------------------+