# DESCRIBE SHARE


> Get details about a specific share by name or URL.

The `DESCRIBE SHARE` statement is used to get details about a specific share.

:::info
The **creator** of the share object can execute this statement by passing the **share name**. The **receiver** of the share object can execute this statement by passing the **share link**.
:::

# Syntax

```sql
DESCRIBE SHARE [<share name> | <share URL>];
```

# Example
Let's use the `sample_data` database which is auto attached to MotherDuck users to illustrate the command

```sql
DESCRIBE SHARE 'md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6';
```

It returns a table with the following columns:

| column_name   | column_type | description                 |
|---------------| ----------- |-----------------------------|
| name          | VARCHAR     | Name of the share           |
| url           | VARCHAR     | URL of the share            |
| source_db_name | VARCHAR     | Name of the database shared |
| source_db_uuid   | UUID        | uid of the database shared  |
| access   | VARCHAR        | Whether anyone (referred to as UNRESTRICTED) within the same cloud region or only organization members (referred to as ORGANIZATION) can attach to the share by its share_url         |
| visibility   | VARCHAR        | Whether the share is DISCOVERABLE or HIDDEN         |
| update   | VARCHAR        | The share’s update mode (MANUAL vs. AUTOMATIC)         |
| created_ts   | TIMESTAMP WITH TIME ZONE        | The share’s creation time         |

You can be specific about what which columns you want to return by using the table function :

```sql
SELECT name, url, source_db_name FROM md_describe_database_share('md:_share/sample_data/23b0d623-1361-421d-ae77-62d701d471e6');
```


---

## Docs feedback

MotherDuck accepts optional user-submitted feedback about this page at `GET https://motherduck.com/docs/api/feedback/agent`.
For agents and automated tools, feedback submission should be user-confirmed before sending.

URL-encode query parameter values and send a GET request:

```text
GET https://motherduck.com/docs/api/feedback/agent?page_path=%2Fsql-reference%2Fmotherduck-sql-reference%2Fdescribe-share%2F&page_title=DESCRIBE%20SHARE&text=<url-encoded user feedback, max 2000 characters>
```

Optionally append `&source=<url-encoded interface identifier>` such as `claude.ai` or `chatgpt`.

`page_path` and `text` are required; `page_title` and `source` are optional. Responses: `200 {"feedback_id": "<uuid>"}`, `400` for malformed query parameters, and `429` when rate-limited.