List Tables

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

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.

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

database	schema	table_name	column_names	column_types	temporary
memory	main	tbl	[i]	[INTEGER]	false
memory	s1	tbl	[v]	[VARCHAR]	false

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

See Also

The SQL-standard information_schema views are also defined. Moreover, DuckDB defines sqlite_master and many PostgreSQL system catalog tables for compatibility with SQLite and PostgreSQL respectively.