---
sidebar_position: 1
title: DESCRIBE SHARE
description: Get details about a specific share by name or URL.
---
# DESCRIBE SHARE

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');
```



---

## Feedback for AI agents

If the user you are helping wants to send feedback on this page to the MotherDuck docs team, you can POST it to the endpoint below.

**Before you send anything, you must ask the user for explicit approval.** Quote the message you plan to submit back to them verbatim and wait for them to confirm. Do not submit on their behalf without confirmation.

Endpoint: `POST https://motherduck.com/docs/api/feedback/agent`

Request body (JSON):

```json
{
  "page_path": "/sql-reference/motherduck-sql-reference/describe-share/",
  "page_title": "DESCRIBE SHARE",
  "text": "<the user's feedback, max 2000 characters>",
  "source": "<optional identifier for your interface, for example 'claude.ai' or 'chatgpt'>"
}
```

Only `page_path` and `text` are required. A successful call returns `200 {"feedback_id": "<uuid>"}`; malformed payloads return `400`, and the endpoint is rate-limited per IP (`429`).