> ## 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.

> 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":"css-variables","dark":"css-variables"}}
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"                              |