Skip to content

Conversation

Mytherin
Copy link
Collaborator

Implements #13950

This PR unifies SHOW/DESCRIBE for tables and for queries. Instead of having a separate code path for when DESCRIBE [table] is called that directly accesses the underlying TableCatalogEntry - we now instead traverse the query plan in DESCRIBE [query] to retrieve constraint information. As a result, we now display constraint information also for queries like DESCRIBE SELECT * FROM tbl, or DESCRIBE SELECT col_name FROM tbl.

In addition, this PR also makes replacement scans work with describe - i.e. we can now run DESCRIBE "file.parquet" or DESCRIBE df directly.

@Mytherin Mytherin merged commit b3c0cea into duckdb:feature Sep 19, 2024
38 checks passed
@Mytherin Mytherin deleted the showconstraints branch December 8, 2024 06:53
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Differences with SHOW TABLE [table name] vs SHOW [table name] and nullability of fields.
1 participant