DROP SHARE¶

Removes the specified share from the system and immediately revokes access for all consumers (i.e. accounts who have created a database from the share).

See also:

CREATE SHARE , ALTER SHARE , SHOW SHARES , DESCRIBE SHARE

Syntax¶

DROP SHARE <name>
Copy

Parameters¶

name

Specifies the identifier for the share 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 share owner, the role with the OWNERSHIP privilege on the share, has the privileges to drop a share. Executing this command with any other role returns an error.

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

  • Dropping a share does not affect the database in the share (or any of the objects in the database).

Important

Before dropping a share, consider the downstream impact of performing this operation:

  • Consumer accounts that have created databases from the share will no longer be able to query these databases.

  • Recreating a share with the same name as a previous share does not restore the databases created (by any consumers) from the share. Each consumer must create a new database from the new share.

  • A dropped share can not be restored. The share must be created again using the CREATE SHARE command and then configured using GRANT <privilege> … TO SHARE and ALTER SHARE.

Examples¶

DROP SHARE sales_s;

+-------------------------------+
| status                        |
|-------------------------------|
| SALES_S successfully dropped. |
+-------------------------------+
Copy