Resources

List Tables

duckdb.org

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 m…

Visit Site

Resources duckdb.org