Updated on 2022-11-18 GMT+08:00

DESCRIBE OUTPUT

Syntax

DESCRIBE OUTPUT statement_name

Description

This statement is used to list the output columns of the prepared statement, including the column name (or alias), catalog, schema, table name, type, type size (in bytes), and a boolean value indicating whether the column is an alias.

Example

--PREPARE my_select1 FROM SELECT * FROM fruit;
  DESCRIBE OUTPUT my_select1;
--PREPARE my_select2 FROM SELECT count(*) as my_count, 1+2 FROM fruit;
  DESCRIBE OUTPUT my_select2;
--PREPARE my_create FROM CREATE TABLE foo AS SELECT * FROM fruit;
  DESCRIBE OUTPUT my_create;