---
sidebar_position: 1
title: LIST SHARES
description: List all shares created by the current user.
---
# LIST SHARES

The `LIST SHARES` statement lists all shares created by the current user.

It provides the same information as querying the [`MD_INFORMATION_SCHEMA.OWNED_SHARES`](/sql-reference/motherduck-sql-reference/md_information_schema/owned_shares/) view. You can also use the table function `md_list_database_shares()` for a subset of this information.

:::tip
To see shares that have been shared *with* you (by others), query the [`MD_INFORMATION_SCHEMA.SHARED_WITH_ME`](/sql-reference/motherduck-sql-reference/md_information_schema/shared_with_me/) view instead.
:::

## Syntax

```sql
-- Using DDL (lists all owned shares with details)
LIST SHARES;

-- Equivalent to querying the information schema view
SELECT * FROM MD_INFORMATION_SCHEMA.OWNED_SHARES;

-- Using table function (returns a subset of columns)
SELECT name, url, source_db_name FROM md_list_database_shares();
```

## Output

The `LIST SHARES` statement and `SELECT * FROM MD_INFORMATION_SCHEMA.OWNED_SHARES` return a table with the following columns:

| Column Name      | Data Type | Value                                                                                                                                             |
| ---------------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------- |
| NAME             | STRING    | The name of the share                                                                                                                             |
| URL              | STRING    | The `share_url` which can be used to attach the share                                                                                             |
| SOURCE_DB_NAME | STRING    | The name of the database where this share was created from                                                                                        |
| SOURCE_DB_UUID | UUID      | UUID of the database where this share was created from                                                                                            |
| ACCESS           | STRING    | Whether anyone (`UNRESTRICTED`) within the same cloud region or only organization members (`ORGANIZATION`) can attach to the share by its `share_url`. RESTRICTED shares are hidden from the list.                          |
| VISIBILITY       | STRING    | Whether the share is `DISCOVERABLE` or `HIDDEN`                                                                                                   |
| UPDATE           | STRING    | The share's update mode (`MANUAL` vs. `AUTOMATIC`)                                                                                                |
| CREATED_TS      | TIMESTAMP | The share's creation time                                                                                                                         |

:::note
Shares are **region-scoped** based on your Organization's cloud region. Each MotherDuck Organization is currently scoped to a single cloud region that must be chosen at Org creation when signing up.

MotherDuck is currently available on AWS in two regions:
- **US East (N. Virginia):** `us-east-1`
- **Europe (Frankfurt):** `eu-central-1`
:::