Syntax
------

SHOW CREATE VIEW view_name

Description
-----------

This statement shows a CREATE VIEW statement that creates the given view, 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 server system variable.

Examples
--------

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 off:

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 and the SELECT
privilege on the view:

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

URL: https://mariadb.com/kb/en/show-create-view/