---
id: "duckdb-show-tables"
title: "Show Tables"
slug: "duckdb-show-tables-query"
description: "List all tables that are loaded using SHOW TABLES or PRAGMA show_tables."
code: |
    -- List all tables using SQL command
    SHOW TABLES;

    -- List all tables using PRAGMA
    PRAGMA show_tables;
---

# DuckDB Show Tables Query

This snippet demonstrates how to list all tables in the current DuckDB database using either the `SHOW TABLES` command or the `PRAGMA show_tables` function.

```sql
-- List all tables using SQL command
SHOW TABLES;

-- List all tables using PRAGMA
PRAGMA show_tables;
```

You can read more about this [here](https://duckdb.org/docs/configuration/pragmas.html#metadata).