DeltaStream
Search
K

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
-------+------+-------------------+----------+-------+------------+-------------