Skip to main content
Lists the columns and column types & properties for a given view or materialized view.
DESCRIBE VIEW Syntax

​
Parameters

VIEW

Optional clause to avoid ambiguity:
  • if given, and a table with the given name exists instead, the command will return an error
  • if omitted, and a table with the given name exists instead, the command will be interpreted as a DESCRIBE TABLE statement

<schema name>

Name of the schema containing the view to describe

<view name>

Name of the view whose configuration will be output

​
Examples

To describe the example view created in the CREATE VIEW section:
DESCRIBE VIEW Example