DuckDB Table Info Query
This snippet demonstrates how to use the PRAGMA table_info function in DuckDB to get detailedinformation about a specific table’s structure.
Try out this query here
-- Returns detailed information about a table's structure
-- Use this to get the column names, types, and other details
PRAGMA table_info('table_name');Example Output
| cid | name | type | notnull | dflt_value | pk |
|---|---|---|---|---|---|
| 0 | id | VARCHAR | false | null | false |
| 1 | conversations | STRUCT(“from” VARCHAR, “value” VARCHAR)[] | false | null | false |
| 2 | category | VARCHAR | false | null | false |
| 3 | subcategory | VARCHAR | false | null | false |
| 4 | task | VARCHAR | false | null | false |
You can read more about this here.