duckdb mydb.duckdb -c "DESCRIBE users;"

Category: Databases & SQL

duckdb mydb.duckdb -c "DESCRIBE users;"

Show a table's columns

Lists each column with its DuckDB type, the same information you would get from a database catalog. Related: SHOW TABLES.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.