---
sidebar_position: 1
title: SHOW ALL DATABASES
description: List all MotherDuck, DuckDB, and shared databases.
---
# SHOW ALL DATABASES

The `SHOW ALL DATABASES` statement shows all databases, would it be MotherDuck database, DuckDB database or MotherDuck shares.

It returns:

* `alias` (`db_name` or `share_alias`)
* `is_attached` flag to mention if the database is attached or not.
* `type` (e.g. DuckDB, MotherDuck, MotherDuck share)
* `fully_qualified_name` (empty, md:_share/ or md:db_name)

To query specific columns, you can use the table function `MD_ALL_DATABASES()`.

# Syntax

```sql
SHOW ALL DATABASES;
```

or using the table function

```sql
select * from MD_ALL_DATABASES();
```

# Example usage

```sql
SHOW ALL DATABASES;
```

Example output:

```bash
┌──────────────────────────────────────────┬─────────────┬──────────────────┬─────────────────────────────────────────────────────────────────────────────────────────┐
│                  alias                   │ is_attached │       type       │                                  fully_qualified_name                                   │
│                 varchar                  │   boolean   │     varchar      │                                         varchar                                         │
├──────────────────────────────────────────┼─────────────┼──────────────────┼─────────────────────────────────────────────────────────────────────────────────────────┤
│ TEST_DB_02d6fc2158094bd693b6f285dbd402f7 │ true        │ motherduck       │ md:TEST_DB_02d6fc2158094bd693b6f285dbd402f7                                             │
│ TEST_DB_62b53d968a4f4b6682ed117a7251b814 │ true        │ motherduck       │ md:TEST_DB_62b53d968a4f4b6682ed117a7251b814                                             │
│ base                                     │ false       │ motherduck       │ md:base                                                                                 │
│ base2                                    │ true        │ motherduck       │ md:base2                                                                                │
│ db1                                      │ false       │ motherduck       │ md:db1                                                                                  │
│ integration_test_001                     │ false       │ motherduck       │ md:integration_test_001                                                                 │
│ my_db                                    │ true        │ motherduck       │ md:my_db                                                                                │
│ my_share_1                               │ true        │ motherduck share │ md:_share/integration_test_001/18d6dbdb-e130-4cdf-97c4-60782ed5972b                     │
│ sample_data                              │ false       │ motherduck       │ md:sample_data                                                                          │
│ source_db                                │ true        │ motherduck       │ md:source_db                                                                            │
│ test_db_115                              │ false       │ motherduck       │ md:test_db_115                                                                          │
│ test_db_28d                              │ false       │ motherduck       │ md:test_db_28d                                                                          │
│ test_db_cc9                              │ false       │ motherduck       │ md:test_db_cc9                                                                          │
│ test_share                               │ true        │ motherduck share │ md:_share/source_db/b990b424-2f9a-477a-b216-680a22c3f43f                                │
│ test_share_002                           │ true        │ motherduck share │ md:_share/integration_test_001/06cc5500-e49a-4f62-9203-105e89a4b8ae                     │
├──────────────────────────────────────────┴─────────────┴──────────────────┴─────────────────────────────────────────────────────────────────────────────────────────┤
│ 15 rows (15 shown)                                                                                                                                        4 columns │
└─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

```