Resources

Describe

duckdb.org

Describing a Table In order 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 In order to view the schema of the result of…

Visit Site