Resources

Describe

duckdb.org

Describing a Table To view the schema of a table, use the DESCRIBE statement (or its aliases DESC and SHOW) followed by the table name. CREATE TABLE tbl (i INTEGER PRIMARY KEY, j VARCHAR); DESCRIBE tbl; SHOW tbl; -- equivalent to DESCRIBE tbl; column_name column_type null key default extra i INTEGER NO PRI NULL NULL j VARCHAR YES NULL NULL NULL Describing a Query To view the schema of the result of a query, prepend…

Visit Site