On this page

DESCRIBE OUTPUT

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

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;
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback