List Tables

The SHOW TABLES command can be used to obtain a list of all tables within the selected schema.

SQL

CREATE TABLE tbl (i INTEGER);
SHOW TABLES;

 name
------
 tbl

SHOW or SHOW ALL TABLES can be used to obtain a list of all tables within all attached databases and schemas.

SQL

CREATE TABLE tbl (i INTEGER);
CREATE SCHEMA s1;
CREATE TABLE s1.tbl (v VARCHAR);
SHOW ALL TABLES;

 database | schema | name | column_names | column_types | temporary
----------+--------+------+--------------+--------------+-----------
 postgres | public | tbl  | {i}          | {INTEGER}    | f
 postgres | s1     | tbl  | {v}          | {VARCHAR}    | f

SHOW TABLES FROM db can be used to list all tables in a given database or schema.

SQL

ATTACH 'db.duckdb';
CREATE TABLE db.main_tbl (u VARCHAR);
CREATE SCHEMA db.s1;
CREATE TABLE db.s1.schema_tbl (v VARCHAR);
SHOW TABLES FROM db;

 name
------------
 main_tbl
 schema_tbl

Or a specific schema.

SQL

SHOW TABLES FROM db61.s1;
DETACH IF EXISTS db61;

 name
------------
 schema_tbl

To view the schema of an individual table, use the DESCRIBE command.

See Also​

See Also