DROP SHARE Statement

Description

The DROP SHARE statement is used to delete an existing share object. Share objects are typically used to share data among multiple users, and deleting a share object will remove this sharing relationship.

Syntax Format

DROP SHARE <share_name>;

Parameter Description

• share_name: The name of the share object to be deleted.

Usage Example

1. Delete the share object named share_1:

   DROP SHARE share_1;
   

2. Delete the share object named `employee_data`, which was previously used to share employee data between different departments:

DROP SHARE employee_data;

Notes

• Before executing the DROP SHARE statement, please ensure that the share object is no longer used by other users or applications to avoid data access exceptions.
• After deleting the share object, the associated sharing permissions will also be removed. If you need to reconfigure sharing permissions, please use the GRANT statement.
• Please operate with caution, deleting the share object is an irreversible operation.

Related Statements

• CREATE SHARE: Create a share object.
• ALTER SHARE: Modify the attributes or permissions of a share object.
• SHOW SHARES: Query the list of existing share objects.