CREATE SHARE

Description

The CREATE SHARE statement is used to create a SHARE object for data management and usage.

Syntax

CREATE SHARE <share_name> ;

Parameter Description

• share_name: Specify the name of the SHARE to be created. The rules for SHARE names are as follows:

  • Supports letters, underscores, and numbers; special characters and spaces are not allowed;
  • Only supports starting with a letter or an underscore, letters are automatically converted to lowercase;
  • Length is 1-255 bytes;
  • Within the same account, share_name must be unique.

Example

Create SHARE

CREATE SHARE share_demo;

CREATE SHARE my_share_2022;

CREATE SHARE my_share;

Notes

• When creating a SHARE, please ensure that the share_name complies with the naming rules, otherwise it will not be successfully created.
• After creating a SHARE, you can use the SHOW SHARES statement to view all SHARES under the current account.
• You can use the DROP SHARE statement to delete SHARES that are no longer needed.

Related Statements

• SHOW SHARES
• DROP SHARE