duckdb mydb.duckdb -c "SHOW TABLES;"

Category: Databases & SQL

duckdb mydb.duckdb -c "SHOW TABLES;"

List tables in the database

Prints the table names in the current database; DESCRIBE users shows one table's columns. Related: SHOW DATABASES.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.