Search Shortcut cmd + k | ctrl + k
Search cmd+k ctrl+k
1.0 (stable)
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.

About this page

Last modified: 2024-06-21