metadata

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.

-- List all tables using SQL command
SHOW TABLES;

-- List all tables using PRAGMA
PRAGMA show_tables;

You can read more about this here.