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.