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;
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.