DROP LISTING

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.
  • 以前发布的列表不会被任何使用者装载。

另请参阅：

CREATE LISTING, ALTER LISTING, DESCRIBE LISTING, SHOW LISTINGS, SHOW VERSIONS IN LISTING, Listing manifest reference

语法

DROP LISTING <name>

参数

name

要删除的列表的标识符。如果标识符包含空格、特殊字符或大小写混合字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

使用说明

  • 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.
  • 删除的列表无法恢复；必须重新创建。
  • 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.
  • 在删除专用列表时，提供商账户列表自动履行 (LAF) 复制组不会删除。要在删除专用列表后解决这个问题，请撤销对复制组的现有授权，然后再删除复制组。例如： 
    GRANT OWNERSHIP ON REPLICATION GROUP myrg TO ROLE accountadmin
REVOKE CURRENT GRANTS;
DROP REPLICATION GROUP myrg;

示例

DROP LISTING IF EXISTS MYLISTING
+----------------------------------+
| status                           |
%----------------------------------%
| MYLISTING successfully dropped. |
+----------------------------------+