DROP STORE

Syntax

DROP STORE store_name;

Description

Drops a store from the organization. Only the store owner can execute this command. Also, you cannot drop a store if there are any relations that depend on the store.

Important DROP STORE cannot be undone. Use it with care!

Arguments

store_name

The name of the store to drop. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

Examples

Drop the current store

The following drops the current store demostore, where the current store name is also reset. You can set a new store using the USE command:

demodb.public/demostore# LIST STORES;
+------------+------------+----------------+------------+-------------+------------+-------------------------------+-------------------------------+
|  Name      |  Type      |  Access Region |  State     |  Is Default |  Owner     |  Created At                   |  Updated At                   |
+============+============+================+============+=============+============+===============================+===============================+
| demostore  | Kafka      | AWS us-east-1  | ready      | true        | sysadmin   | 2024-05-09 22:39:40 +0000 UTC | 2024-05-09 22:39:40 +0000 UTC |
+------------+------------+----------------+------------+-------------+------------+-------------------------------+-------------------------------+
demodb.public/demostore# DROP STORE demostore;
+------------+------------+------------+------------------------------------------+
|  Type      |  Name      |  Command   |  Summary                                 |
+============+============+============+==========================================+
| store      | demostore  | DROP       | store "demostore" has been marked for    |
|            |            |            | deletion                                 |
+------------+------------+------------+------------------------------------------+
demodb.public/<no-store>#

When you drop a default store for the current organization, you can set a new one withSET DEFAULT to use for the succeeding sessions of the organization that owns the store.