DROP STORE

Syntax

DROP STORE store_name;

Description

Drops a Store from the organization. It can only be executed by the Store owner. A Store cannot be dropped if there are any relations that depend on the Store.

DROP STORE cannot be undone. Use it with care!

Arguments

store_name

The name of the Store to drop. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

Examples

Drop a Store

The following drops the Store named demostore:

demodb.public/demostore# LIST STORES;
    Name    | Kind  | Availability zone | Metadata |  Owner   |      Created at      |      Updated at
------------+-------+-------------------+----------+----------+----------------------+-----------------------
  demostore | Kafka | us-east-1         | {}       | sysadmin | 2022-08-22T17:01:05Z | 2022-08-22T17:01:05Z
demodb.public/demostore# DROP STORE demostore;
demodb.public/<no-store># LIST STORES;
  Name | Kind | Availability zone | Metadata | Owner | Created at | Updated at
-------+------+-------------------+----------+-------+------------+-------------