> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DESCRIBE VIEW

Lists the columns and column types & properties for a given
[view](/content/sql/ddl/create-view#sql-create-view) or
[materialized view](/content/sql/ddl/create-materialized-view#sql-create-materialized-view).

```sql title="DESCRIBE VIEW Syntax" theme={null}
DESC[RIBE] [VIEW] [<schema name>.]<view name>
```

## Parameters

<AccordionGroup>
  <Accordion title="VIEW" id="view" defaultOpen>
    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
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* containing the *view* to describe
  </Accordion>

  <Accordion title="<view name>" id="<view-name>" defaultOpen>
    Name of the *view* whose configuration will be output
  </Accordion>
</AccordionGroup>

## Examples

To describe the example *view* created in the
[CREATE VIEW](/content/sql/ddl/create-view#sql-create-view) section:

```sql DESCRIBE VIEW Example theme={null}
DESC VIEW example.view_of_table
```