# SHOW CREATE VIEW

## Syntax

```sql
SHOW CREATE VIEW [view-name]
```

## Description

This statement shows a [CREATE VIEW](https://mariadb.com/docs/server/server-usage/views/create-view) statement that creates the given [view](https://mariadb.com/docs/server/server-usage/views), as well as the character set used by the connection when the view was created. This statement also works with views.

`SHOW CREATE VIEW` quotes table, column and stored function names according to the value of the [sql\_quote\_show\_create](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#sql_quote_show_create) server system variable.

## Examples

```sql
SHOW CREATE VIEW example\G
*************************** 1. row ***************************
                View: example
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL
SECURITY DEFINER VIEW `example` AS (select `t`.`id` AS `id`,`t`.`s` AS `s` from
`t`)
character_set_client: cp850
collation_connection: cp850_general_ci
```

With [sql\_quote\_show\_create](https://mariadb.com/docs/server/server-management/variables-and-modes/server-system-variables#sql_quote_show_create) off:

```sql
SHOW CREATE VIEW example\G
*************************** 1. row ***************************
                View: example
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECU
RITY DEFINER VIEW example AS (select t.id AS id,t.s AS s from t)
character_set_client: cp850
collation_connection: cp850_general_ci
```

## Grants

To be able to see a view, you need to have the [SHOW VIEW](https://mariadb.com/docs/server/reference/account-management-sql-statements/grant#table-privileges) and the [SELECT](https://mariadb.com/docs/server/reference/account-management-sql-statements/grant#table-privileges) privilege on the view:

```sql
GRANT SHOW VIEW,SELECT ON test_database.test_view TO 'test'@'localhost';
```

## See Also

* [Grant privileges to tables, views etc](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant)

<sub>*This page is licensed: GPLv2, originally from*</sub> [<sub>*fill\_help\_tables.sql*</sub>](https://github.com/MariaDB/server/blob/main/scripts/fill_help_tables.sql)

{% @marketo/form formId="4316" %}