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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands/metadata/show-views",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference and syntax for the SHOW VIEWS command.

# SHOW VIEWS

Lists the views defined in the current database and the `CREATE VIEW` statement that defines each view.

For more information regarding views, see [information\_schema.views](/reference-sql/information-schema/views).

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SHOW VIEWS;
```

## Returns

The returned table has the following columns.

| Column name      | Data Type | Description                                |
| :--------------- | :-------- | :----------------------------------------- |
| view\_name       | TEXT      | The name of the view.                      |
| view\_definition | TEXT      | The query statement that defines the view. |

## Example

The following example displays the view name and view definition of a views in the database queried:

**Returns**:

| view\_name | schema                                                                                                      |
| :--------- | :---------------------------------------------------------------------------------------------------------- |
| v14        | CREATE VIEW "v14" AS SELECT a.\* FROM (SELECT 1 AS "x") AS "a" INNER JOIN (SELECT 1 AS "x") AS "b" USING(x) |
| v15        | CREATE VIEW IF NOT EXISTS "v15" AS SELECT \* FROM "bf\_test\_t" WHERE ( "n" = 0 )                           |
| v16        | CREATE VIEW "v16" AS WITH x7 AS (SELECT \_ FROM "oz\_x6" ) SELECT \_ FROM "x7"                              |