# DESCRIBE STORE

## Syntax

```sql
DESCRIBE STORE store_name;
```

## Description

This provides the definition of an existing [Store](https://docs.deltastream.io/overview/core-concepts/store).

Stores are listed only if the current role has USAGE privileges.

### Arguments <a href="#parameters" id="parameters"></a>

#### store\_name

This is the name of the store to describe. If the name is case-sensitive, you must wrap it in double quotes; otherwise, the system uses the lowercase name.

## Examples

#### Describe a store

The following describes the store named `demostore`:

```sh
demodb.public/demostore# DESCRIBE STORE demostore;
+-------------+------------------------------------------+----------+--------------+------------------+------------------+
|  Properties |  Uri                                     |  Details |  Tls Enabled |  Verify Hostname |  Schema Registry |
+=============+==========================================+==========+==============+==================+==================+
| {}          | b-1.kafka:9196,b-2.kafka:9196,b-3.kafka: | {}       | true         | true             | <null>           |
|             | 9196                                     |          |              |                  |                  |
+-------------+------------------------------------------+----------+--------------+------------------+------------------+
```

#### Describe a case-sensitive store

The following describes the store named `MyStore`:

```sh
demodb.public/demostore# DESCRIBE STORE "MyStore";
+-------------+------------------------------------------+----------+--------------+------------------+------------------+
|  Properties |  Uri                                     |  Details |  Tls Enabled |  Verify Hostname |  Schema Registry |
+=============+==========================================+==========+==============+==================+==================+
| {}          | b-1.kafka:9196,b-2.kafka:9196,b-3.kafka: | {}       | true         | false            | <null>           |
|             | 9196                                     |          |              |                  |                  |
+-------------+------------------------------------------+----------+--------------+------------------+------------------+
```