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
 

 
 
 
 
 
 
 

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