Removes the specified listing from the system and immediately revokes access for all consumers.
Important
Before dropping a listing, ensure that:
The listing is in state DRAFT or UNPUBLISH. For more information about changing listing states, see ALTER LISTING.
Previously published listings are not mounted by any consumers.
See also:
Syntax¶ Parameters¶CREATE LISTING, ALTER LISTING, DESCRIBE LISTING, SHOW LISTINGS, SHOW VERSIONS IN LISTING, Listing manifest reference
name
The identifier of 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.
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.
Provider account Listing Auto-Fulfillment (LAF) replication groups don’t get dropped when you drop a private listing. To resolve this issue after you drop a private listing, revoke the existing grants on the replication group and then drop the replication group. For example:
GRANT OWNERSHIP ON REPLICATION GROUP myrg TO ROLE accountadmin REVOKE CURRENT GRANTS; DROP REPLICATION GROUP myrg;
Copy
DROP LISTING IF EXISTS MYLISTINGCopy
+----------------------------------+ | status | |----------------------------------| | MYLISTING successfully dropped. | +----------------------------------+
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4