The DESCRIBE statement shows the schema of a table, view, or query.
Usage
DESCRIBE tbl;
To describe a query, prepend DESCRIBE to a query.
DESCRIBE SELECT * FROM tbl;
Alias
The SHOW statement can also describe tables and queries, but this usage is deprecated as of DuckDB 2.0 and prints a warning.
See Also
For more examples, see the guide on DESCRIBE.
© 2026 DuckDB Foundation, Amsterdam NL