# SHOW CREATE VIEW

Shows the `CREATE VIEW` statement that was used to create the view.

## Syntax

```
SHOW CREATE VIEW view_name

```

## Arguments

**view\_name**

The name of the view.

## Remarks

* The `Create View` field from the output can be used to recreate the view.
* The output also contains information on `character_set_client` and `collation_connection`. See [List of Engine Variables](https://docs.singlestore.com/db/v9.1/reference/configuration-reference/engine-variables/list-of-engine-variables.md) for more information.
* See the [Permission Matrix](https://docs.singlestore.com/db/v9.1/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permission.

## Example

The following example displays the output of `SHOW CREATE VIEW` for the `shipped_products` view from [CREATE VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-view.md).

```sql
SHOW CREATE VIEW shipped_products\G

```

```output
*** 1. row ***
                View: shipped_products
         Create View: CREATE DEFINER=`root`@`%` SCHEMA_BINDING=OFF VIEW `shipped_products` AS SELECT `orders`.`product_id` AS `product_id`, `orders`.`quantity` AS `quantity` FROM `orders` as `orders`  WHERE (NOT ISNULL(`orders`.`quantity`))
character_set_client: utf8mb4
collation_connection: utf8mb4_bin
```

**Related Topics**

* [CREATE VIEW](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-definition-language-ddl/create-view.md)

***

Modified at: December 11, 2025

Source: [/db/v9.1/reference/sql-reference/show-commands/show-create-view/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/show-commands/show-create-view/)

(An index of the documentation is available at /llms.txt)